| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return next highest number in range
I have tried doing this with INDEX and MATCH but can't get my head round it.
I have 2 columns of data, containing blanks that are the result of an IF formula. 40 100 100 200 400 600 800 1200 1600 The values will always be sorted from low to high. What I need to do is take the max value from column B (400 in this case) and return the next highest value from column A (600). Grateful for any pointers on this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'conditional format' cells for the highest number in a range | Excel Discussion (Misc queries) | |||
| how can i choose the highest number in excel range | Excel Worksheet Functions | |||
| return rating of which number is highest and descending in column | Excel Worksheet Functions | |||
| how do I change the font of highest number in a range of cells | New Users to Excel | |||
| How do I return the highest value in a range of cells | Excel Worksheet Functions | |||
Threaded Mode
