We help IT Professionals succeed at work.

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

207 Views
Last Modified: 2017-04-11
=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
Comment
Watch Question

Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
You cannot. This is how excel executes excel formulas.
Managing Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Wow. Shams thank you.

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