MrExcel Publishing
Your One Stop for Excel Tips & Solutions

First occurance


Posted by lenze on May 11, 2001 7:00 AM

Say I have a list of values in column A2:A12. I would like to place a formula in cells C2:C12 which would check the value in the same row in column A and return TRUE if it is the first occurance of that value and FALSE if it is a duplicate

Thanx


Posted by Mark W. on May 11, 2001 7:14 AM

Enter =COUNTIF($A$2:$A2,A2)=1 into C2 and copy
down.