| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookup function to return highest value
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function to return highest value | Excel Worksheet Functions | |||
| Function to return the highest combined value of ANY two values in a list? | Excel Worksheet Functions | |||
| Return sum of values based on lookup-function | Excel Worksheet Functions | |||
| Lookup function - can it return the higher value? | Excel Discussion (Misc queries) | |||
| return range of data from lookup function | Excel Worksheet Functions | |||
Threaded Mode
