How to make list of unique values?

  • Thread starter Thread starter ybm
  • Start date Start date
Y

ybm

I have a excel worksheet having list of few items. One or more items ar
repeated in the list. I want to have the list of unique items out o
this list on seperate sheet. How to achieve this? Suggest me the exce
function(s) to get such lis
 
Hi ybm

you can do this using the Data / Filter / Advanced Filter

click on the sheet where you want the unique list copied to
choose data / filter / advanced filter
click in the "copy to another location" radio button
click in the "Copy To" white box
click on the cell where you want the unique list to be copied to
click in the list range box
click on the sheet where the current list is
click on the column with the list in it (or select the range)
tick the "Unique Records only" box
click OK

this should give you what you're after

Cheers
JulieD
 
Back
Top