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)))`

EE.xlsx
You cannot. This is how excel executes excel formulas.

ASKER CERTIFIED SOLUTION

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.

ASKER

Wow. Shams thank you.

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

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