Excel Forum



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.