Listing all items only once

[guttyguppy]

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?

 

[CLR]

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/primitivesoftware/products.php

Vaya con Dios,
Chuck, CABGx3