Excel Forum
Similar Content
Filter Data to Show the Top 10 Items from a Data Set in Excel - AutoFilter
Macro: This Excel macro filters data in Excel in order to display the top 10 items from the data ...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Remove All Filtering From a Worksheet in Excel
Macro: This Excel macro removes all filtering from a worksheet in Excel. This allows you to compl...



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.