Spreadsheet: 148365d1333375996-top-25-list-from-data-set-temp
Sheet: Summary

 | Top 25 accounts
 | 01 |  | equals nothing as there is more black cells than filled cells
 | 02 |  | added -1 to end of [NAME] count to get it to calculate the second most frequent count but it errors on text over 1 character long
 | 03 |  | [NAME] to large and changed K to 3 to get 3rd largest value
 | 04
 | 05
 | 06
 | 07
 | 08
 | 09
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | Row Labels | Count of Account ID
 | NOVAR1 | 87
 | FCF1 | 85
 | NEW17 | 67
 | FIRE5 | 59
 | [NAME] | 58
 | PRI22 | 57
 | PLA3 | 54
 | MAP2 | 53
 | EASTS002 | 52
 | PRI21 | 44
 | OPT3 | 28
 | FIR9 | 27
 | R0RBS1 | 26
 | [NAME] | 24
 | WF0S1 | 23
 | IDM3 | 19
 | EST1 | 18
 | SWS1 | 17
 | EASTL004 | 17
 | PRO1 | 16
 | WOKBC1 | 15
 | [NAME] | 15
 | KRW1 | 15
 | NEWEY2 | 14
 | SHEPFM1 | 14
 | ABB9 | 13
 | SBC5 | 12
 | BOSCH1 | 12
 | SAINS003 | 11
 | WFE1 | 11
 | AMECF001 | 11
 | NEW001 | 10
 | ROU1 | 10
 | NAZAR001 | 10
 | WHO1 | 9
 | C0I1 | 9
 | DENMAN1 | 9
 | MFP2 | 8
 | WSR1 | 8
 | TOZER1 | 8
 | CAL1 | 8
 | APM1 | 8
 | WESTNHS1 | 7
 | TOW9 | 7
 | MITIE2 | 7
 | MASON001 | 6
 | VTG1 | 6
 | PRE2 | 6
 | MKE1 | 6
 | TMKC1 | 6
 | NHS5 | 6
 | EPSCO1 | 6
 | ALF3 | 6
 | IGS3 | 6
 | SENATE1 | 5
 | SOLIT001 | 5
 | NHS8 | 5
 | TSSF1 | 5
 | SAINS002 | 5
 | ANGLI002 | 5
 | BPB2 | 5
 | CBCR1 | 5
 | GDS2 | 5
 | BRY4 | 5
 | LBN1 | 5
 | JCL3 | 5
 | [NAME] | 5
 | SDN1 | 4
 | TVL2 | 4
 | SPI1 | 4
 | MRSOS1 | 4
 | WFE001 | 4
 | NHS4 | 4
 | SEN001 | 4
 | PAR16 | 4
 | MITIE1 | 4
 | PARTY1 | 4
 | MJE1 | 4
 | MAL7 | 4
 | [NAME] | 4
 | SHARP002 | 4
 | FMB1 | 4
 | EASTL005 | 4
 | DHA3 | 4
 | CON17 | 4
 | BAE1 | 4
 | BRIBEL1 | 4
 | BUS12 | 4
 | LDS1 | 4
 | KERNE001 | 4
 | CDS1 | 4
 | AYLES001 | 4
 | CYC2 | 4
 | CHTPCT1 | 4
 | LAM6 | 4
 | WESTW1 | 3
 | STKC1 | 3
 | SRCL1 | 3
 | NOR18 | 3
 | MIG3 | 3
 | PATT1 | 3
 | WHATM001 | 3
 | NOR6 | 3
 | STEDM1 | 3
 | [NAME] | 3
 | THO7 | 3
 | RAYTH001 | 3
 | LYD1 | 3
 | LWL1 | 3
 | PACIF002 | 3
 | [NAME] | 3
 | OFF1 | 3
 | [NAME] | 3
 | BIOQ1 | 3
 | LAN6 | 3
 | KIL4 | 3
 | CAN1 | 3
 | BSD4 | 3
 | B0PD1 | 3
 | BUS5 | 3
 | CBR2 | 3
 | BOULT001 | 3
 | EEP1 | 3
 | GCN1 | 3
 | ADVFS1 | 3
 | GKNAE001 | 3
 | CFP1 | 3
 | CORY5 | 3
 | BPB3 | 3
 | ABS3 | 3
 | [NAME] | 3
 | KINGS2 | 3
 | BHP2 | 3
 | EAEL1 | 3
 | [NAME] | 3
 | CGMA1 | 3
 | LANDM001 | 3
 | TRM1 | 2
 | QUA9 | 2
 | WAY1 | 2
 | LFCH1 | 2
 | QUIZN001 | 2
 | SAINWPD1 | 2
 | TUD2 | 2
 | SBC1 | 2
 | PARKER1 | 2
 | OAK8 | 2
 | TMP2 | 2
 | OAKLA001 | 2
 | MISSACT1 | 2
 | WHL2 | 2
 | OMM2 | 2
 | PRI17 | 2
 | URL1 | 2
 | SIR1 | 2
 | P0K1 | 2
 | SMITH2 | 2
 | ROC5 | 2
 | MCDON001 | 2
 | TLM3 | 2
 | SON1 | 2
 | [NAME] | 2
 | SOU14 | 2
 | TOWER001 | 2
 | MONDL1 | 2
 | [NAME] | 2
 | LEWIS001 | 2
 | TROXY001 | 2
 | SPR4 | 2
 | TTH2 | 2
 | MAR13 | 2
 | PGR4 | 2
 | SSCLLP1 | 2
 | [NAME] | 2
 | QFP1 | 2
 | WESTM1 | 2
 | QKN1 | 2
 | PMWP1 | 2
 | STMC2 | 2
 | MKP1 | 2
 | MCS7 | 2
 | SAINCV1 | 2
 | THA6 | 2
 | MBUTT1 | 2
 | SHALAM1 | 2
 | ISSCO001 | 2
 | GLL1 | 2
 | BROCK1 | 2
 | CEC1 | 2
 | GSF1 | 2
 | EASTNHS1 | 2
 | DAVES001 | 2
 | ALL1 | 2
 | BFU1 | 2
 | EBULL001 | 2
 | [NAME] | 2
 | BUS11 | 2
 | CPS5 | 2
 | EMPIR002 | 2
 | JFM1 | 2
 | [NAME] | 2
 | CARIL003 | 2
 | BOWEA001 | 2
 | [NAME] | 2
 | ESSEX007 | 2
 | GLASS002 | 2
 | CIN2 | 2
 | GRATTE1 | 2
 | CLE7 | 2
 | GRICE001 | 2
 | FIO1 | 2
 | AYL3 | 2
 | CLEAN009 | 2
 | INT1 | 2
 | COL12 | 2
 | BRI18 | 2
 | COLART1 | 2
 | KENTS001 | 2
 | ATFB1 | 2
 | DCNEW1 | 2
 | BUS6 | 2
 | ALD1 | 2
 | GDL1 | 2
 | EAS4 | 2
 | BUSIN003 | 2
 | AJT1 | 2
 | GEC2 | 2
 | CONCO001 | 2
 | LBTEC1 | 2
 | CORY1 | 2
 | CORY4 | 2
 | DCK1 | 2
 | THESPE1 | 1
 | MKW2 | 1
 | PLA16 | 1
 | PRO4 | 1
 | SWS24 | 1
 | [NAME] | 1
 | TOW13 | 1
 | NICQU001 | 1
 | WCS2 | 1
 | QPP1 | 1
 | STONE001 | 1
 | QSD1 | 1
 | [NAME] | 1
 | NINER001 | 1
 | TLSE1 | 1
 | QUE2 | 1
 | NEWOU001 | 1
 | QUI2 | 1
 | VICTO002 | 1
 | NLM1 | 1
 | LILLY002 | 1
 | MARA1 | 1
 | [NAME] | 1
 | [NAME] | 1
 | STTHO002 | 1
 | NOISY001 | 1
 | PARK001 | 1
 | RAY16 | 1
 | TESL1 | 1
 | [NAME] | 1
 | [NAME] | 1
 | REGPC1 | 1
 | TNBC1 | 1
 | MORRI001 | 1
 | TPO2 | 1
 | REYN1 | 1
 | TTCH1 | 1
 | RGCM1 | 1
 | UNDER001 | 1
 | RHENU001 | 1
 | WAD2 | 1
 | RLHA1 | 1
 | NEWPCT1 | 1
 | ROBER003 | 1
 | MAN10 | 1
 | NOR19 | 1
 | WOK1 | 1
 | ROC9 | 1
 | STMMC1 | 1
 | ROM9 | 1
 | STPC8 | 1
 | MARGO1 | 1
 | SWEET1 | 1
 | RSA1 | 1
 | TARGE001 | 1
 | RSM1 | 1
 | TCS1 | 1
 | RUTRC1 | 1
 | TEL5 | 1
 | RWR1 | 1
 | THAME008 | 1
 | SAI9 | 1
 | THREE003 | 1
 | SAINAL1 | 1
 | TIR3 | 1
 | SAINBD1 | 1
 | LOND1 | 1
 | MORRI1 | 1
 | TORQU001 | 1
 | SAINEK1 | 1
 | PEMBR001 | 1
 | SAINEL1 | 1
 | TRHG1 | 1
 | SAINEPD1 | 1
 | TSH1 | 1
 | SAINGR1 | 1
 | PIXEL001 | 1
 | SAINND1 | 1
 | TWE2 | 1
 | SAINNR1 | 1
 | PMSIN001 | 1
 | [NAME] | 1
 | [NAME] | 1
 | NORTH003 | 1
 | WATER2 | 1
 | SAINSDD1 | 1
 | WEL2 | 1
 | [NAME] | 1
 | WESTS002 | 1
 | NOTRA001 | 1
 | LOW1 | 1
 | SAINWPR1 | 1
 | WHL1 | 1
 | SAS1 | 1
 | WINST001 | 1
 | SASA1 | 1
 | WOO7 | 1
 | SAVILLS1 | 1
 | NHS7 | 1
 | MORSS1 | 1
 | STNCH1 | 1
 | MAXIN001 | 1
 | STPC7 | 1
 | SBS2 | 1
 | STPP1 | 1
 | SCORE001 | 1
 | SWBC1 | 1
 | SCSL1 | 1
 | MCL2 | 1
 | NPSPR001 | 1
 | TAMBA1 | 1
 | SECUR001 | 1
 | TAURE001 | 1
 | SEDLE001 | 1
 | TBH1 | 1
 | OAK2 | 1
 | TCS6 | 1
 | MBDS1 | 1
 | TDR3 | 1
 | SER8 | 1
 | TEN3 | 1
 | [NAME] | 1
 | PARK2 | 1
 | [NAME] | 1
 | THE14 | 1
 | MON3 | 1
 | LINW1 | 1
 | SHI8 | 1
 | THU8 | 1
 | [NAME] | 1
 | TILTAX1 | 1
 | OCT1 | 1
 | LJJ1 | 1
 | SKANS2 | 1
 | LFP1 | 1
 | SKANS3 | 1
 | PAYMC1 | 1
 | SLIMJ001 | 1
 | TOP7 | 1
 | SMAAC1 | 1
 | TOTAL2 | 1
 | SMC14 | 1
 | PCM1 | 1
 | ODY1 | 1
 | PENN1 | 1
 | SMMC | 1
 | PGG1 | 1
 | MUSIC1 | 1
 | PGR2 | 1
 | MWS1 | 1
 | TRUM1 | 1
 | ONEFA001 | 1
 | PINEL002 | 1
 | SOU3 | 1
 | PIPLS1 | 1
 | SOU4 | 1
 | TUHS1 | 1
 | SOU9 | 1
 | [NAME] | 1
 | OPT2 | 1
 | ULTIM001 | 1
 | SPEED001 | 1
 | LYN4 | 1
 | NAB1 | 1
 | VES001 | 1
 | SPM1 | 1
 | VJM1 | 1
 | [NAME] | 1
 | [NAME] | 1
 | SPSP1 | 1
 | WALKE004 | 1
 | OTT1 | 1
 | PMW1 | 1
 | LINMC1 | 1
 | WE3R | 1
 | STACC1 | 1
 | WESTH001 | 1
 | STAPC1 | 1
 | POW4 | 1
 | NEGTE001 | 1
 | MORG1 | 1
 | STEVE1 | 1
 | PRESS003 | 1
 | STHCH1 | 1
 | WHAMC1 | 1
 | STJ1 | 1
 | WHEAT1 | 1
 | STJBC1 | 1
 | NHS6 | 1
 | STJOHN1 | 1
 | WILLI002 | 1
 | STJTE1 | 1
 | MAP7 | 1
 | PAH1 | 1
 | [NAME] | 1
 | STLC2 | 1
 | WSH1 | 1
 | STLC3 | 1
 | ZING1 | 1
 | NESP1 | 1
 | STMC7 | 1
 | [NAME] | 1
 | KLIXP001 | 1
 | INPR1 | 1
 | [NAME] | 1
 | FLI2 | 1
 | B0NYM1 | 1
 | AROMA001 | 1
 | [NAME] | 1
 | JOHNB001 | 1
 | 24VIN1 | 1
 | LCONS1 | 1
 | CHA15 | 1
 | BSE2 | 1
 | CHA25 | 1
 | GLENS001 | 1
 | CHAMC1 | 1
 | HUAL1 | 1
 | CHR8 | 1
 | JAGUA001 | 1
 | CHRIS005 | 1
 | [NAME] | 1
 | CHRIS006 | 1
 | AVS2 | 1
 | AFGHAN1 | 1
 | AMS10 | 1
 | BAK3 | 1
 | FRI1 | 1
 | CITY2 | 1
 | ACK1 | 1
 | CLE20 | 1
 | AOG1 | 1
 | CLE6 | 1
 | [NAME] | 1
 | BALFO001 | 1
 | HOLL1 | 1
 | BAR1 | 1
 | ASCOT1 | 1
 | CLEAN033 | 1
 | ADAMS001 | 1
 | BARN2 | 1
 | CANAR003 | 1
 | BAS6 | 1
 | JUSTB001 | 1
 | COMP3 | 1
 | CASHC3 | 1
 | BASIL002 | 1
 | [NAME] | 1
 | BATTL001 | 1
 | LANDS001 | 1
 | COO4 | 1
 | AMP1 | 1
 | COOL1 | 1
 | FIRST006 | 1
 | COR7 | 1
 | AMS8 | 1
 | [NAME] | 1
 | GATTO1 | 1
 | CORY2 | 1
 | BTC2 | 1
 | AGU1 | 1
 | GEO5 | 1
 | BBB3 | 1
 | GILTE001 | 1
 | COTT1 | 1
 | ACS5 | 1
 | CPL2 | 1
 | GOLD1 | 1
 | BDR1 | 1
 | BUSIN004 | 1
 | CRADL001 | 1
 | HIREA001 | 1
 | CRAW1 | 1
 | HONGK001 | 1
 | CUBE2 | 1
 | C0I3 | 1
 | CURVE001 | 1
 | IMPAKT1 | 1
 | CUT2 | 1
 | INTER2 | 1
 | CVH2 | 1
 | IVAN1 | 1
 | BEACO002 | 1
 | [NAME] | 1
 | D0SE1 | 1
 | JLOCK1 | 1
 | DAHAS001 | 1
 | JST1 | 1
 | DAN5 | 1
 | CANT1 | 1
 | DAT1 | 1
 | CAS1 | 1
 | BEL3 | 1
 | [NAME] | 1
 | DAY4 | 1
 | KSH2 | 1
 | DCCE1 | 1
 | LAI3 | 1
 | 02SHO001 | 1
 | LANDE001 | 1
 | DCMAR1 | 1
 | ADM1 | 1
 | BEN10 | 1
 | CEN5 | 1
 | DCRICH1 | 1
 | FIRE4 | 1
 | DEN001 | 1
 | FIREF001 | 1
 | 37OAK001 | 1
 | [NAME] | 1
 | DEW1 | 1
 | AMS5 | 1
 | ALBAP001 | 1
 | FODEN001 | 1
 | [NAME] | 1
 | FRI3 | 1
 | DIA3 | 1
 | GCDN1 | 1
 | DINER002 | 1
 | GDFSH001 | 1
 | [NAME] | 1
 | AMS9 | 1
 | [NAME] | 1
 | GEM5 | 1
 | DTS1 | 1
 | GEO9 | 1
 | DUN6 | 1
 | GILLM1 | 1
 | BIL3 | 1
 | GJBOW001 | 1
 | EARLY001 | 1
 | GLA2 | 1
 | ALC3 | 1
 | GLCS1 | 1
 | BISHO001 | 1
 | BUSIN002 | 1
 | BITTA001 | 1
 | GRAHR1 | 1
 | EASTL006 | 1
 | GRC1 | 1
 | BOL2 | 1
 | C0HC1 | 1
 | 38EGG1 | 1
 | HERB1 | 1
 | A1ESS002 | 1
 | HOLB1 | 1
 | [NAME] | 1
 | HOMEW001 | 1
 | 20HAR001 | 1
 | HSP1 | 1
 | EGLH1 | 1
 | IDH1 | 1
 | EHMC1 | 1
 | IFC2 | 1
 | EHW1 | 1
 | IIED001 | 1
 | ELB1 | 1
 | INCARE1 | 1
 | ELYO1 | 1
 | CALOR001 | 1
 | EMA3 | 1
 | ISG5 | 1
 | ALL13 | 1
 | ITSU002 | 1
 | EMS2 | 1
 | [NAME] | 1
 | EMSS1 | 1
 | JARM1 | 1
 | ALL7 | 1
 | [NAME] | 1
 | ENGIN004 | 1
 | [NAME] | 1
 | ENTER001 | 1
 | JOH21 | 1
 | ALLEN001 | 1
 | JPS4 | 1
 | EPSCO2 | 1
 | JUL3 | 1
 | ERGRO1 | 1
 | JUSTI001 | 1
 | ESCAPE1 | 1
 | AVLSC001 | 1
 | ESGL1 | 1
 | KHF1 | 1
 | ESS27 | 1
 | [NAME] | 1
 | BPH1 | 1
 | KITESCS1 | 1
 | BRADD001 | 1
 | KLE1 | 1
 | EST4 | 1
 | [NAME] | 1
 | ETS2 | 1
 | CASHC8 | 1
 | EXPRE001 | 1
 | LAFA1 | 1
 | EXR1 | 1
 | CATER1 | 1
 | EXX1 | 1
 | AWGFA001 | 1
 | 2224S001 | 1
 | CBT5 | 1
 | FCH2 | 1
 | LAZ2 | 1
 | FENT1 | 1
 | ADME2 | 1
 | FFLY1 | 1
 | CEMA1 | 1
 | FIN8 | 1
 | BRI9 | 1
 | Grand Total | 2049