|
| Posted by: CanEHdian Pride
- [3723210] Wed, Aug 25, 2004, 22:03
Hey Excel Experts....i have a problem.
I have a single report that I've consolidated from 5 other reports.
The "master" report is supposed to have totals for each product code from the five "child" reports. So basically I have a sorted list of product codes with there associated cost and I need to generate a list of product codes without duplicates so that I can generate formulas to calculate the totals.
Anyone have any idea how to do this? |
| | | 1 | TB
Leader
ID: 031811922
Wed, Aug 25, 2004, 22:09
|
Your up in the RIFC.
|
|
| | | 2 | CanEHdian Pride
ID: 3723210
Wed, Aug 25, 2004, 22:12
|
yeah, i'm heading there....trying to get something done for work though....run into a road block...i'll pick shortly
|
|
| | | 3 | culdeus
Leader
ID: 43105818
Wed, Aug 25, 2004, 22:24
|
Before I take a shot at this let me restate the question.
Of the 5 reports sometimes one product code shows up on one or more reports? Yes?
You combine all the reports into one sheet with the same column headings and data format and sort them by #?
You want to eliminate duplicates?
First step will be creating an IF column (hidden) where you do a check
=IF(Below row=current row, 1,0)
Hang on I think I can make this happen....go pick.
|
|
| | | 4 | CanEHdian Pride
ID: 3723210
Wed, Aug 25, 2004, 22:31
|
yeah..that is what i need...
however I think if I SUM each column and use the SUBTOTAL function that I can have all of the duplicates collapse under one subtotal heading.....is this right?
|
|
| | | 5 | culdeus
Leader
ID: 43105818
Wed, Aug 25, 2004, 22:58
|
how much data are we talking here? 400 4000 40000 rows?
|
|
| | | 6 | CanEHdian Pride
ID: 3723210
Wed, Aug 25, 2004, 22:58
|
I also found a method using "Data->Consolidate"
where you give the product code and cost a range name and then the above command totals the values and erases duplicates......i think that is exactly what I was looking for.
|
|
| | | 7 | CanEHdian Pride
ID: 3723210
Wed, Aug 25, 2004, 23:02
|
about 600 rows
|
|
|
|