removing non duplicate data

  • Thread starter Thread starter freeman
  • Start date Start date
F

freeman

I have a worksheet that has one column of data, most of it is repeated. What
I would like is to have a formula that will take the data in column one and
take out the non repeated data and put that in column two.
 
No formula will do that. Use Data - Filter - Advanced Filter and specify
Unique records. That will display only the unique records in Column A.
Copy that and paste it to Column B. HTH Otto
 
Back
Top