Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




YouTubersLoveExcel#32: Delete Unique Records: MATCH & ROW


Use the MATCH & ROW functions to create a logical test to find the First Occurrence of items in a list with duplicates.

See how to use the MATCH function to find only the first occurrence of an item in a list with duplicates.
See how to use the ROW function to count by ones. See how to use the ROW function to create a list of whole numbers.

Se the logical formula: =MATCH(D14,$D$14:$D$29,0)=ROW(A1)





Got a Question? Ask it Here in the Forum.