G
Guest
I have two worksheets in one document and would like to reference totals from
one worksheet and display the results (by highest total, first) on the second
worksheet. For example:
Worksheet 1
SOLD Week 1 Week 2 Total Sold
Oranges 2 3 5
Pears 0 1 1
Apples 5 5 10
On Worsheet 2, I would like to show the following:
Highest Sold:
Apples 10
Oranges 5
Pears 1
Not sure how I would display this so that Apples (in this case, the highest
total) would appear on top and Pears (in this case, the lowest total) would
appear on the bottom.
Any help that you can provide is welcome. Thanks.
G
one worksheet and display the results (by highest total, first) on the second
worksheet. For example:
Worksheet 1
SOLD Week 1 Week 2 Total Sold
Oranges 2 3 5
Pears 0 1 1
Apples 5 5 10
On Worsheet 2, I would like to show the following:
Highest Sold:
Apples 10
Oranges 5
Pears 1
Not sure how I would display this so that Apples (in this case, the highest
total) would appear on top and Pears (in this case, the lowest total) would
appear on the bottom.
Any help that you can provide is welcome. Thanks.
G