|
|
Featured Tutorial
Featured Macro
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
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