F
flyers2thecup
i'm trying to reconcile two separate reports. one report has a total.
the other, has a bunch of rows that get to a total.
here's an example:
Code
-------------------
COL A COL B
ROW 1 22222 $5.00
ROW 2 11111 $2.50
ROW 3 22222 $1.00
ROW 4 11111 $9.05
ROW 5 22222 $4.55
ROW 6 11111 $3.32
I'm trying to find out the total of all the 22222s and the 11111s
in the list. in this case i would need an output of something like
this:
22222 $10.55
11111 $14.87
-------------------
i can then compare my totals to the totals of the other report.
this is simple when the list is this small. but i have a report o
over 1500 lines.
any ideas? is this even possible?
I'm running XP and have EXCEL 2000.
thanks in advance!!
the other, has a bunch of rows that get to a total.
here's an example:
Code
-------------------
COL A COL B
ROW 1 22222 $5.00
ROW 2 11111 $2.50
ROW 3 22222 $1.00
ROW 4 11111 $9.05
ROW 5 22222 $4.55
ROW 6 11111 $3.32
I'm trying to find out the total of all the 22222s and the 11111s
in the list. in this case i would need an output of something like
this:
22222 $10.55
11111 $14.87
-------------------
i can then compare my totals to the totals of the other report.
this is simple when the list is this small. but i have a report o
over 1500 lines.
any ideas? is this even possible?
I'm running XP and have EXCEL 2000.
thanks in advance!!