Hey all
I have column a with huge list of numbers with so many duplicates when sorted by number.
is there a way to create in B a new filtered list of numbers which will eliminate all duplicates and keep only one number of it, and so on going down?
thanks
Evil is the root of all Mon$y
Hi,
select your data
Go to Data - Filter - Advanced filter and follow the wizard - Don't forget to check" unique records only"
HTH
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
works
thanks
Evil is the root of all Mon$y
Originally Posted by legolas
Thank MS for that
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks