I have column of values and most of those values appear repeatedly. What formula or set of formulas can I use to return all of the unique values of within the column?
Thanks,
Justin
I have column of values and most of those values appear repeatedly. What formula or set of formulas can I use to return all of the unique values of within the column?
Thanks,
Justin
you could just use data/advanced filter/ unique values /copy to
unles you really need a function
look here
http://www.cpearson.com/excel/noblanks.htm
Last edited by martindwilson; 09-09-2008 at 06:56 PM.
Try this
I think it's what you need
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks