Quote:
Originally Posted by BDAvs
On Sheet1, I have a number of categories all with running totals. On Sheet2 I have some of the same categories. I want to continue the running total on Sheet2, but need to know how to return the running total (largest value in each category) from Sheet1.
e.g.
Sheet 1
Column N Column AL
Apples ....1
Apples ....4
Apples ....6
Oranges ....2
Oranges ....4
Oranges ....9
...
Sheet 2
Column N Column AL (want)
Apples ....6
Apples
Apples
Apples
Oranges ....9
Oranges
Oranges
Thanks for any help!
BD
|
Have a look at the attached. Is this what you mean?
It's an "array formula" so you need to confirm them by pressing Ctrl, Shft and Enter rather than just Enter.