Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"rolling up" numbers
I've fairly large worksheets, around 20 to 25k rows each. 20 in total.
Some of the data contained within is as follows: Req ID Source Interview Hired 1234 website 2 0 1234 commercial 10 2 1234 website 1 1 1234 magazine 3 0 I need to keep the data as a basic list as it is now (no combining figures via pivot or anything), but I'd like to find a way to automate the combining of data for redundant sources. In the example data, "website" source is listed twice with different figures. I need a way to consolidate it to one row, summing the figures in Interview and Hired. Any ideas would be greatly appreciated. Thanks in advance, Brad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers to date: "586" to read "May 1986" | Excel Worksheet Functions | |||
Formula: How do I create a "rolling" sum in excel? | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) |