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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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