Excel Forum



Excel Magic Trick 696: Identify First Occurrence In Column (5 methods)


Create a column of 1s and 0s (ones and zeroes) where 1 indicates the first occurrence and 0 indicates any remaining duplicates. Five methods as seen at the Mr Excel Message Board:
1. N and COUNTIF function
2. N and COUNTIFS function
3. COUNTIF and zero
4. ISNUMBER and MATCH
5. SUM, FREQUENCY, IF, INDEX, MATCH, ROW functions

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm





Got a Question? Ask it Here in the Forum.