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.
