Excel: Data analysis help -

I have very detailed P&L with G/L accounts by month. The trial balances by month are provided in each tab column A is G/L number (e.g., 40102, 40103, 40120, etc), column B is account name (revenues, ancillary revenues, etc) and column C is amount. The problem is G/L account numbers are not consistent across month meaning 40102 in January may not be in february, or there may be G/L accounts in september that are not present in any of the other months. I want to create a master list of G/L accounts from each month (with no duplicates) so i can create consolidated P&L in single tab by using vlookup from the monthly tabs). What's the easiest way to capture and dump all the G/L accounts from the monthly tabs onto a single tab? Any ideas?

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of November 01, 2013.

For more resources for Microsoft Excel