Code Guy
Reputation: 3198
Return unique row using a query formula
I have a data as shown in the spreadsheet (Here is the link to sheet)
Where I need to get the uniques when both columns B and C considered, The col B is a date type
=QUERY(UNIQUE(FILTER(A:E,C:C="Daniel Workman")))
The expected result is indicated in yellow color
Upvotes: 1
Views: 33
Answers (1)
player0
Reputation: 1
use:
=FILTER(A9:E18, COUNTIFS(B9:B18&C9:C18, B9:B18&C9:C18)=1, C9:C18="Daniel Wokman")
and:
=FILTER(A9:E18, COUNTIFS(B9:B18&C9:C18, B9:B18&C9:C18)=1, C9:C18="Morgan Freeman")
Upvotes: 1
Related Questions
- Google Sheets Query Function. How can I get only Unique or Distinct Rows?
- UNIQUE formula + IF
- Google sheets query on unique range
- Make Some Columns Not Repeat Values with Google Sheets Query Formula
- How to count unique values with the QUERY function of google sheets?
- Unique QUERY based on IFS, AND formula in Google Sheets
- How to pick one of the results of UNIQUE() in Google Sheets
- Google Sheets show only one unique row using Query
- Get unique row by certain values
- return unique values in a table with 2 columns using excel formulas