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