Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | FRANK | GEORGE | JULIE | MIKAEL | LUIS | ||
2 | APPLE | KIWI | APPLE | TANGERINE | KIWI | ||
3 | ORANGE | ORANGE | KIWI | TANGERINE | PEAR | ||
4 | ORANGE | ORANGE | ORANGE | TANGERINE | PEAR | ||
5 | APPLE | ORANGE | ORANGE | ORANGE | PEAR | ||
6 | PEAR | ORANGE | ORANGE | ORANGE | KIWI | ||
7 | PEAR | ORANGE | ORANGE | ORANGE | KIWI | ||
8 | KIWI | ||||||
9 | |||||||
10 | APPLE | ORANGE | PEAR | KIWI | TANGERINE | ||
11 | FRANK | FRANK | FRANK | GEORGE | MIKAEL | ||
12 | JULIE | GEORGE | LUIS | JULIE | |||
13 | JULIE | LUIS | |||||
14 | MIKAEL | ||||||
15 | |||||||
16 | |||||||
2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A11 | {=IFERROR(INDEX($A$1:$E$1,SMALL(IF(FREQUENCY(IF($A$2:$E$8=A$10,MATCH($A$1:$E$1,$A$1:$E$1,0)),ROW($A$2:$E$8)-ROW($A$2)+1),ROW($A$2:$E$8)-ROW($A$2)+1),ROWS($A$10:A10))),"")} | |
Press CTRL+SHIFT+ENTER to enter array formulas. |
The Links in the footer of your Post DO NOT work for me. Is there a URL I can download software?
Mac Excel doesn't have VBA so it won't work for you unfortunately.Can't get that to work on my mac!