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