Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying a uniques entity composed of two columns
I have 1,500 cost centers and 32 accounts...on a sheet (data) that has 18,000
rows I need to find the unique combination of cost center + account (1,500 of these combination across 32 accounts) on the "data" sheet then copy the 12 month of information onto another sheet. I can accomplish this using worksheet functions but it takes 6 minutes to recalculate and I have to do it 32 times (onec for each account). I was hoping the I could create a macro that would speed this process up..... Any help would be appreciated Thanks -- Helping Is always a good thing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting duplicates and uniques comparing two columns | Excel Worksheet Functions | |||
Finding the last value entered for an entity | Excel Programming | |||
formula for extracting uniques using 2 columns | Excel Programming | |||
Print area composed by more ranges | Excel Discussion (Misc queries) | |||
Identifying Duplicates in Columns | Excel Worksheet Functions |