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

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

I tried a few arrays, and all crashed my Excel (55k rows is a heck of a lot
of rows). I would say just use a Pivot Table; there is almost no limit to
the size of the data parameters that you can deal with.

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

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