| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Next Largest Number Based on Criteria
I have a problem that is stumping me. In cells A1 through A10, I have numbers 1-10. In cells B1-B10 I have corresponding identifiers, Apples, Oranges, Pears. It looks like this A B 1 Apples 2 Apples 3 Oranges 4 Oranges 5 Apples 6 Pears 7 Oranges 8 Pears 9 Oranges 10 Apples I need a formula that I can copy down that looks in column B for "Oranges" and returns the corresponding number that is next largest above the number it already found. The result would look like below... 3 4 7 9 Any feedback would be most helpful. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the Max Number in a Table based on Other Criteria | Excel Programming | |||
| FInding the largest number in a range meeting a criteria | Excel Discussion (Misc queries) | |||
| Finding the largest number help | Excel Discussion (Misc queries) | |||
| Finding a number based on a criteria | Excel Worksheet Functions | |||
| Finding the Largest Number, based on two criteria | Excel Discussion (Misc queries) | |||
![djc[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
