Thread: Count if statement
View Single Post
 
Old 10-28-2019, 04:53 PM
Alansidman's Avatar
Alansidman Alansidman is offline Windows 10 Office 2019
עַם יִשְׂרָאֵל חַי
  
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 115
Alansidman has a spectacular aura aboutAlansidman has a spectacular aura aboutAlansidman has a spectacular aura about
Default
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.
Reply With Quote