Data analysis help -

[Dope]

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?

 

[hiker95]

Hercules1946,

It seems likely that Dope has found another solution, which happens often.

I think so.

The good news is that we have both gained from it. Im very impressed with your work on the arrays, and Im glad to see your off and running with the dictionary
which is really useful in many situations as Im sure you have realised.

Thank you very much for the compliment.

 

[hiker95]

Private Message from Dope today:

Re: Data analysis help -

Thank you, hiker. This was helpful. Appreciate the help.

Quote Originally Posted by hiker95

Dope,

On your latest thread, please see my replies #8 and #10.

The GetUniqueGLNumbers macro runtime is 0.000 seconds, and, also contains running totals.

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.

 

[Hercules1946]

Hello Dope
Its nice to hear that your problem was eventually sorted.

Well done Hiker

 

[hiker95]

Hercules1946,

Thanks again, and, have a great day.