Forum Discussion

littlevillage's avatar
littlevillage
Iron Contributor
Aug 03, 2022
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 hav...
excel
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Aug 04, 2022

    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's avatar
Harun24HR
Bronze Contributor
Aug 04, 2022

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)

 

 

 

 

Resources