CODEWITHSUNDEEP
sortinggoogle-sheetsuniquegoogle-sheets-formulaarray-formulas
AnAccountName
AnAccountName

Reputation: 31

Google Sheets, Sort table based on unique values in a single column

I am currently trying to use google sheets to sort a table based on the unique values found in only two of the columns.

What I want to happen is that columns A (Brand) and B (Dimensions) are both checked for unique values, removing any duplicate data.

The problem is using these two columns to filter and show the rest of table. I can't managed to achieve it.

Original Data

enter image description here

What is should look like after being culled

enter image description here

.

Upvotes: 3

Views: 869

Answers (2)

pkowalczyk
pkowalczyk

Reputation: 18453

You can use Query function:

=query(A1:D8,"select A, B, min(C), min(D)  group by A, B",1)

Example Example spreadsheet

Upvotes: 1

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(SORT(SPLIT(TRANSPOSE(QUERY(TRANSPOSE(SORTN(
 IF(A2:C<>"", {"♦"&A2:A&"♦"&B2:B, "♦"&C2:D}, ), 99^99, 2, 1, 1))
 ,,99^99)), "♦"), 2, 1))

0

Upvotes: 0

Related Questions