i have a list of email addresses in the first column on 10 worksheets. some
of them are duplicates. is there a formula to compile a list of all of the
emails from all of the worksheets without showing duplicates?

ex: is in sheets, 1, 3, 7, and 10

i would like to show only one list where is only outputted
once.

i think this is a vlookup function, but i read that there is a 7 worksheet
maximum lookup?

thanks for your help in advance. hope someone can help.

Download and install the free add-in Morefunc.xll from:
http://www.download.com/Morefunc/300...-10423159.html

....then use this formula

=INDEX(UNIQUEVALUES(THREED(Sheet1:Sheet3!$A$1:$A$1 00),1),ROWS($1:1))


"monkeytrader" wrote:

i have a list of email addresses in the first column on 10 worksheets. some
of them are duplicates. is there a formula to compile a list of all of the
emails from all of the worksheets without showing duplicates?

ex: is in sheets, 1, 3, 7, and 10

i would like to show only one list where is only outputted
once.

i think this is a vlookup function, but i read that there is a 7 worksheet
maximum lookup?

thanks for your help in advance. hope someone can help.