display unique data from several columns of data

elaine216 · Mar 13, 2007

Hi,

I have several columns of data, they are all names.

Some of the names are duplicate within the range of columns. Is
there
a way to display a unique list of data in the next available column?

Thanks.
Elaine.

Randy Harmelink · Mar 18, 2007

There is a handy UDF to help get unique items. See:

http://www.exceltip.com/st/Look_up_unique_values_using_VBA_in_Microsoft_Excel/527.html

Otherwise, you could also do an advanced filter, telling it to keep
only the unique items.

display unique data from several columns of data

elaine216

Randy Harmelink