Get Unique Record in Google Sheet

Get Unique Record in Google Sheet

To get unique records in Google Sheets, you can use the UNIQUE formula. The UNIQUE formula returns a list of unique values in a range of cells. Here's how to use the UNIQUE formula:

1. Select a cell where you want to display the unique values.
2. Type the following formula in the cell:
• =UNIQUE(range)

Replace "range" with the range of cells that you want to extract unique values from.

      3. Press Enter.

The UNIQUE formula will return a list of unique values from the specified range. Note that the UNIQUE formula only returns unique values, so if there are duplicates in the range, they will be removed.

If you want to extract unique values from multiple ranges, you can use the QUERY formula with the UNIQUE and ARRAYFORMULA functions. Here's an example:

1. Select a cell where you want to display the unique values.
2. Type the following formula in the cell:
• =QUERY(UNIQUE({range1; range2}), "SELECT * WHERE Col1 <> '' ")

Replace "range1" and "range2" with the ranges of cells that you want to extract unique values from. Separate the ranges with a semicolon.

     3 Press Enter.

The QUERY formula will return a list of unique values from the specified ranges. Note that the ARRAYFORMULA function is used to apply the UNIQUE formula to each range, and the SELECT statement is used to filter out any blank cells.