Forum Discussion
Solved
How can write a formula to filter Duplicate values
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
https://docs.google.com/spreadsheets/d/1IoPqfScU62DlIoh8SJgftdIcJOZEJzDK/edit?usp=sharing&ouid=112310544159929632856&rtpof=true&sd=true
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)
2 Replies
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)
