Find or lookup the 2nd 3th... "different" match in column

with a helpcolumn to add the values.

with a helpcolumn to count.

then sort the data on name.

after that a filter on the value 1.

See the attached file.

In G3:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Drag down to G5

For banana starts from row 7: Copy G3 to G8, replace $2 to $7, then Ctrl-shift-enter, Drag down

Similar to Kivi row 12
Replace $2 to $12

Based on bebo021999 formula:

Put "Apple" ,"Banana","Kivi" in G2,H2,I2 (add more as required)

Put this in G3 and Enter with Ctrl+Shift+Enter

=IFERROR(INDEX($B$2:$B$13,MATCH(0,IF($A$2:$A$13=G$2,COUNTIF($G$2:G2,IF($A$2:$A$13=G$2,$B$2:$B$13,"")),""),0)),"")

Copy across and down

This avoids having to adjust ranges in each formula.

Another array-entered formula. It is a bit longer than the others. It's only redeeming feature is that it can be started in row 1.

Formula:

Please Login or Register  to view this content.

Confirmed with Ctrl + Shift + Enter.