counting unique names - again

[John K]

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.

 

[Bernard Liengme]

You need to tell us in a little more detail how the sheet is laid out
best wishes

 

[ryguy7272]

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--

 

[ryguy7272]

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--