Aug 03 2022 04:53 PM
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
Aug 03 2022 08:26 PM - edited Aug 03 2022 08:30 PM
SolutionLittle 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)
Aug 21 2022 02:19 AM
Aug 03 2022 08:26 PM - edited Aug 03 2022 08:30 PM
SolutionLittle 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)