Listing all items only once
 

I have a column with lots of different data in each cell, but some are
the same. For instance, I have under column C, a bunch of job numbers,
some of which are the same. I want to assign a collumn to display all
the job numbers, but not duplicates. How can I do this?


--
guttyguppy
------------------------------------------------------------------------
guttyguppy's Profile: http://www.excelforum.com/member.php...o&userid=35491
View this thread: http://www.excelforum.com/showthread...hreadid=552637

Listing all items only once
 

If this is something you have to do regularly, then you might be interested
in Jim Cone's fine commercial Add-in called XL Compnion. It's available at
......

http://www.realezsites.com/bus/primi...e/products.php

Vaya con Dios,
Chuck, CABGx3



"guttyguppy" wrote:


I have a column with lots of different data in each cell, but some are
the same. For instance, I have under column C, a bunch of job numbers,
some of which are the same. I want to assign a collumn to display all
the job numbers, but not duplicates. How can I do this?


--
guttyguppy
------------------------------------------------------------------------
guttyguppy's Profile: http://www.excelforum.com/member.php...o&userid=35491
View this thread: http://www.excelforum.com/showthread...hreadid=552637