I have two column like this:
id x_id data
1 11 abc
1 11 abc
1 12 vbn
2 11 abc
2 11 abc
I want to find unique values like this
1 11 abc
1 12 vbn
2 11 abc
In my case col a and b are the key . I want to find unique values by using two column combined
which I can do by using sql
SELECT * FROM table group by a,b
Assign a name to the entire data range in Data > Define Range. Thereby open the Options and check the needed options, likely Contains column labels and Insert or delete cells. That way you can use a named filter and do not conflict with other filters.
After the range is named, select it, e.g. by Data > Select Range. Then use Data > More Filters > Standard Filters. Use the Condition = and the value Not Empty for those columns, which should become duplicate-free, connect with operator AND. That way, the condition should be always true. (I assume, that you do not have empty cells in the range.)
Open the Options and check No duplications and in Copy results to you enter the address of the top,left cell of the target range for the duplicate-free data. OK. You need to copy the data, because otherwise only the rows containing duplicates are hidden.
If your source data has changes you can update the duplicate-free data by selecting the source range and then using Data> Refresh Range.