SOLVED

How can write a formula to filter Duplicate values

Iron Contributor

Hi,

I use Conditional Formating to show duplicate values In column A and B

I want to get the rest of values in column A after remove duplivate values

How can I write a formula for that case

I have added an image and the link of the samplfile below

Hope for your response

Thank you

 

small_village_0-1659570461829.png

https://docs.google.com/spreadsheets/d/1IoPqfScU62DlIoh8SJgftdIcJOZEJzDK/edit?usp=sharing&ouid=11231... 

2 Replies
best response confirmed by littlevillage (Iron Contributor)
Solution

@littlevillage 

Little bit confusing. To extract duplicate values from a column use below formula-

 

=UNIQUE(FILTER(A1:A8,COUNTIF(A1:A8,A1:A8)>1))

 

And to extract duplicate values use below formula

 

=FILTER(A1:A8,COUNTIF(A1:A8,A1:A8)=1)

 

 

 

 

@Harun24HR 

Thank you

That's so useful for me

1 best response

Accepted Solutions
best response confirmed by littlevillage (Iron Contributor)
Solution

@littlevillage 

Little bit confusing. To extract duplicate values from a column use below formula-

 

=UNIQUE(FILTER(A1:A8,COUNTIF(A1:A8,A1:A8)>1))

 

And to extract duplicate values use below formula

 

=FILTER(A1:A8,COUNTIF(A1:A8,A1:A8)=1)

 

 

 

 

View solution in original post