First Occurences

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

I know that hthe Count Function will count the number of times that a
item occures in a list. I want to know how do I tell if its the firs
ocurrence? That is, I only want to know True/False if its the firs
occurence.

Thank
 
Hi
lets assume your data is in column A then use the following formula in
B1
=IF(COUNTIF($A$1:$A1,A1)=1,"First occurence","")
and copy this down for all rows
 
Back
Top