Link to home
Start Free TrialLog in
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

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of excelismagic
excelismagic

ASKER

Wow. Shams thank you.

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