Excel Forum



Excel Magic Trick #148: Dynamic List from Table #3


See how to how to extract records from non-standard table and put a record in a column. See how to use the functions; IF, ROWS, INDEX, MATCH, COUNTIF functions.

See how to create a field of unique items to use with the VLOOKUP function from a table that is not set up properly (data is NOT in "Database" or "Excel List" or "Excel Table" format (field names at top of each column, records in rows)).
ALSO: SEE HOW TO USE THE ROWS FUNCTION TO INCRENETENT NUMBERS (1, 2, 3) IN A FORMULA.





Got a Question? Ask it Here in the Forum.