Easer way?: Select 1st on 1 occurrence, Select 2nd on 2occurrences; Select 3rd on 3 occ.

[kofeincek]

Need to select Select 1st occurrence if no duplicates , Select 2nd occurrence if 2duplicates ; Select 3rd occurrence if 3 duplicates ....

SOLVED with additional columns:
- first column =COUNTIF(A:A;A2) counts number of occurrences
- second column: =COUNTIF($A$2:$A2; $A2) identify 1st, 2nd, 3rd,
- third column: IF numbers in previous two columns the same pick that one, else don't pick

OR

To use single column only : =IF(COUNTIF(A:A;A2)=COUNTIF($A$2:$A2; $A2);" pick";"dont pick")

Ideas for faster and easier solution although this one is pretty simple already?

Screen 1632 (Mobile).jpg

[AliGW]

Which version of Excel? Please update your profile to show ONLY the version you are using and need help with.

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[Fluff13]

Another way is

=IF(ROW()=XMATCH(A2,$A$1:$A$100,0,-1),"Pick","Don’t Pick")

[kofeincek]

TNX Fluff13. I love this solution too, as it presents school example of XMatch searching from last. upwards.

[Fluff13]

Glad to help & thanks for the feedback.