Excel Forum
Similar Content
Print Different First Page in Excel
Tutorial: How to include different information, headers, or footers, on the first page when printin...
Combine Data from Multiple Worksheets in Excel
Tutorial: The easiest way to combine and consolidate data in Excel. Simple method to combine data ...
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...



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.