![]() |
|
#2
|
||||
|
||||
|
In C2 type =INDEX($A$2:$A$7,MATCH(B2,$B$2:$B$7,0),MATCH(MIN($ A$2:$A$7),$A$2:$A$7,0)) and copy down.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Converting a Select statement in Excel to an update statement | shabbaranks | Excel Programming | 5 | 10-31-2018 11:47 PM |
IF statement
|
mrry475 | Excel | 1 | 09-06-2016 09:30 AM |
Getting the Count formula to count all rows
|
Jennifer Murphy | Word Tables | 11 | 08-23-2016 09:37 PM |
Count if statement
|
Alaska1 | Excel | 7 | 05-30-2014 08:57 AM |
if statement
|
piper7971 | PowerPoint | 1 | 08-19-2010 07:10 AM |