I have the following two columns of data:
Location Value
A 1
A 1
B 2
C 2
D 3
D 3
E 4
E 4
F 5
G 5
If there is a duplicate combination of Location
and Value
, it has to be DELETED. If I use the remove duplicate option, the duplicates are removed but retains one of the repeated values and that is not favorable for me. My intended output is this:
Location Value
B 2
C 2
F 5
G 5
Here is what I've thought and tried so far:
I concatenated the two columns and then used COUNTIF
to get a count of the number of times a value is repeated. I can then filter the count column by only considering the counts that equal to 1. This is shown here:
However, this method of mine is not feasible dues to various other filters and sorting that has been done in my spreadsheet.
Are there any other suggestions to achieve the same results as I have?