Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help with summative column (VLOOKUP???)
We have a big spreadsheet here at work with about 40 columns. One of
them, let's say it's column H, contains the names of some school districts. Some of them occur more than once in that column. Column I contains that district's code number. Another column, say column N, contains an amount for that district. This also appears more than once. For example: H I N Houston 23 150 Dallas 48 400 Austin 15 250 Dallas 48 250 Houston 23 100 Austin 15 350 .... and so on, for over 2000 rows. What I need is a formula for Columns P, Q and R where P and Q would list each district and its code number ONE TIME, and R would list the total amounts for that district. Note: this can NOT be sorted prior to executing the formla. EXAMPLE: for the above example, P, Q and R would look like: P Q R Houston 23 250 Dallas 48 650 Austin 15 600 I can't figure this one out; I hope it's not terribly difficult. The actual spreadsheet includes about 80 different districts appearing anywhere from once to over 100 times. And again, I can't sort it first - it's too big and complex and sorting would mess it up. This needs to be just three nice, neat, additional columns. Of course, those columns could be sorted later, no problem there. Anybody want to tackle this one? Our administrative assistants would be mucho grateful. Thanks, Ron M. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup for Column b | Excel Worksheet Functions | |||
vlookup 1st column time 2nd column text | Excel Worksheet Functions | |||
VLookup - Column name? | Excel Discussion (Misc queries) | |||
vlookup a value in column B but return value in Column A | Excel Discussion (Misc queries) | |||
VLookup & Column Sum | Excel Worksheet Functions |