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
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)
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)
