Situation:
A1 B1 C1 D1 E1
1 10/15/02 Joe John 100 100
2 10/15/02 John Joe 200 200
3 10/15/02 Joe Joe 300 -0-
Amount in D1 corresponds to name in B1 and amount in E1 corresponds to name in C1 and so forth down the rows.
Is there a way to make a report that would pull the name only once from column B1 & C1 and display (and total) the corresponding amounts in D1 and E1. For example, from above, the report would display:
Joe 100
200
300
_0__
Total 600
The report doesn't have to appear exactly as shown. I just want some ways of extracting the numbers (and totaling it) corresponding to the name. Is it possible?
Any help would be greatly appreciate.
Thank you.
Toan
A1 B1 C1 D1 E1
1 10/15/02 Joe John 100 100
2 10/15/02 John Joe 200 200
3 10/15/02 Joe Joe 300 -0-
Amount in D1 corresponds to name in B1 and amount in E1 corresponds to name in C1 and so forth down the rows.
Is there a way to make a report that would pull the name only once from column B1 & C1 and display (and total) the corresponding amounts in D1 and E1. For example, from above, the report would display:
Joe 100
200
300
_0__
Total 600
The report doesn't have to appear exactly as shown. I just want some ways of extracting the numbers (and totaling it) corresponding to the name. Is it possible?
Any help would be greatly appreciate.
Thank you.
Toan