Allen, I couldn't find it on the website you indicated, (Found it on another
site)

I got it to work, had to select all the cells with the formula and hit
CTRL/SHIFT/ENTER. But, my destination has the potential for 50 unique entries
from a column of 320, I'm getting #N/A in all the cells (45) except the 5
with unique entries.


"Alan Beban" wrote:

Did you download the file from the Web site?

Alan Beban

Mark wrote:
Thanx Alan, but I got #NAME?. I did hit CTRL+SHIFT+ENTER

"Alan Beban" wrote:


Mark wrote:

...into a single occurance. I have 1 sheet that can have multiple text
(Client) entries, duplicates permited. On another sheet I would like to see
each text entry only once. I'll use this "field/result" with a sumproduct to
determine total items by Client.

If the functions in the freely downloadable file at
http://home.pacbell.net are available to your workbook

=ArrayUniques(rangeName)

array entered into a column of cells sufficient to accommodate the
number of unique entries will return a list of unique values.

Alan Beban