|
Featured Tutorial
Featured Macro
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.
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.