This is relatively fast:
=COUNT(1/FREQUENCY(A1:A55000,A1:A55000))

Many of the other methods of doing this require arrays, and when you deal
with lots of rows (i.e. 55k rows), things slow down to a speed that is quite
simply intolerable...


Regards,
Ryan--


--
RyGuy


"Bernard Liengme" wrote:

You need to tell us in a little more detail how the sheet is laid out
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"John K" wrote in message
...
All, have a monster spreadheet, 55K rows, 25 columns ... need to count
Unique Support Tech Names based on three criteria; Rpt Date( Jan 19); Work
Type (New), Region (France), everything in Range Names, playing with array
functions all day to no avail.
--
John K aka BigMan