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