counting unique names - again
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 |
counting unique names - again
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 |
counting unique names - again
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 |
counting unique names - again
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 |
All times are GMT +1. The time now is 07:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com