| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Criteria to return maximum value where x = x
Good morning,
I have an Excel file with two sheets, sheet 1 contains two columns of data, column A has text and column B has numbers. In sheet 2, I have a list if unique text that matches that in column A of sheet 1. I need to place a formula alongside the unique list in sheet 2 to return the highest corresponding value in sheet 1 i.e. the value in column B. Below is an example of what I'm looking to achieve. Any pointers most welcome. Thanks, Rob col a col b 01 30 02 29 01 31 02 30 01 34 col c col d 01 want to return 34 02 want to return 30 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning a Min and Maximum Value by two criteria | Excel Discussion (Misc queries) | |||
| Return Maximum from Column directly above Maximum in Row | Charts and Charting in Excel | |||
| Maximum value based on criteria | Excel Discussion (Misc queries) | |||
| Return Maximum value for Specific Month(s) | Excel Worksheet Functions | |||
| Return Maximum value | Excel Discussion (Misc queries) | |||
Threaded Mode
