Data Clean Up
 

Hi Guys,

I need to do some data clean up.

I need to output unique data only.

For example:

Column A has 15 records, Column B has 10 records but I want column C
to have 5 unique records, records that aren't in aither column A or B.

TIA!

Dolphy

Data Clean Up
 

Hello Dolphy
See Chip Peasron's http://www.cpearson.com/excel/ListFunctions.aspx

HTH
Cordially
Pascal

"Dolphy" a écrit dans le message de news:
...
Hi Guys,

I need to do some data clean up.

I need to output unique data only.

For example:

Column A has 15 records, Column B has 10 records but I want column C
to have 5 unique records, records that aren't in aither column A or B.

TIA!

Dolphy