Author: Oscar Cronquist Article last updated on February 11, 2018

Table of contents

  1. Filter unique distinct row records
  2. Filter unique distinct row records but not blanks
  3. Filter unique distinct row records that does not begin with *string*
  4. Filter unique distinct row records that begins with *string*
  5. Filter unique distinct records [Pivot table]


Question: How do I extract unique distinct records from this list?

Answer:

First, let me explain unique distinct records. A record is an entire row in the table, in this example. The picture below displays a small table in column B and C containing a duplicate record. The table in column E and F contains only unique distinct records.