Unigue codes from 1 Column on 3 different sheets
Posted by Leon on August 29, 2001 6:49 AM
Is there a way to do this with arrays, names or some other function?
I have one column on 3 separate sheets within a workbook that contain various department codes. Some of the codes within each column of each sheet will be duplicates while others will be unique. I want my array/name/some unknown function to contain all of the codes from each column of each sheet but not duplicates. Thanks in advance to those within the forum