Finding Unique records


E

eva cheng

I am using Excel 2003, I have a column of records which may duplicated. How
can I extract the unique records to a list by using a formula not advance
filtering

Thanks
 
Ad

Advertisements

E

eva cheng

As I want the list to be updated automatically (my boss doesn't familiar with
excel) when the records are changed, is it possible to do with a formula or
macro ?

Thanks
 
Ad

Advertisements

D

Dave Peterson

If you're ok with a macro, you could record one when you do the advanced filter
with unique records checked.

Then rerun that macro whenever you needed to update that unique list.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top