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...
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Combine Data from Multiple Worksheets in Excel
Tutorial: The easiest way to combine and consolidate data in Excel. Simple method to combine data ...



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.