| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add multiple entries and display on another sheet
When theres more than one of the same value in one column, what formula
would I need to use to add data associated with that value in corresponding columns and display the results on a separate worksheet. The number of instances can vary, so next time, Joe may have 3 instances, Sam 4..... So that this on one worksheet: resource hours Joe 5 Joe 8 Sam 17 Peter 2 Peter 7 Peter 23 Results in the following on another worksheet resource hours Joe 13 Sam 17 Peter 32 Your help is appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to display last few entries | Excel Worksheet Functions | |||
| Lookup: Multiple Occurances | Excel Worksheet Functions | |||
| How to display selected table entries from another worksheet? | Excel Worksheet Functions | |||
| How do I get entries over 1000 characters to display in a cell? | Excel Discussion (Misc queries) | |||
| Merge, update, and add only new entries into a list from other she | Excel Worksheet Functions | |||
Threaded Mode
