I would copy and paste all 12 column A's to one new sheet, appending each to
the bottom of the list making one long column A..........then I would use Jim
Cone's commercial add-in called XL Companion to extract a list of
uniques..........

the add-in is available at

http://www.realezsites.com/bus/primitivesoftware/

Vaya con Dios,
Chuck, CABGx3



"JN" wrote:

I have multiple worksheets (Jan-Dec) where a text value has been entered in a
column (col A) that includes blank cells. I need to look at all the text
values in col A, worksheets Jan-Dec, come up with a list of unique text
values and create a list in a separate worksheet. Is this even possible? I
cannot find a formula that will work with text.
Thanks in advance for any assistance!