Link to home
Avatar of excelismagic
excelismagic

asked on

how can this formula be modified so that it doesn't require control shift enter

=INDEX($A$2:$A$11, SMALL(IF(COUNTIF($B$2:$B$11, $A$2:$A$11), MATCH(ROW($A$2:$A$11),ROW($A$2:$A$11)), ""), ROWS($A$1:A1)))

Open in new window

EE.xlsx
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

You cannot. This is how excel executes excel formulas.
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of excelismagic
excelismagic

ASKER

Wow. Shams thank you.

for a moment, i believed what Saqib mentioned.  this is really cool