Spreadsheet: 686356d1594552094-list-most-frequently-occurring-strings-n-most-repetitive-words-in-a-sheet-range-sample3
Sheet: ResultSheet

 |  | For the range --> TargetSheet!$A$1:$ZZ$1000 |  |  |  |  | For the range --> TargetSheet!$A$1:$F$1000
 |  | As you can see no data is shown probably because of pivotTable. |  |  |  |  | In this case data is shown.
 |  |  | 0 |  |  |  |  | 5
 |  | Value | Count
 |  | HG23 | 3
 |  | PD27 | 3
 |  | XD99 | 3
 |  | WX41 | 3
 |  | CU54 | 3
 |  | XS37 | 3
 |  | CC47 | 3
 |  | RD99 | 3
 |  | HP69 | 3
 |  | IR65 | 3
 |  | XK59 | 3
 |  | XM35 | 3
 |  | FV57 | 3
 |  | KK97 | 3
 |  | RJ34 | 3
 |  | KO45 | 3
 |  | [NAME] | 3
 |  | RF67 | 3
 |  | VW80 | 3
 |  | RV99 | 3
 |  | BY24 | 3
 |  | DA37 | 3
 |  | JH76 | 3
 |  | [NAME] | 3
 |  | UK82 | 3
 |  | HQ44 | 3
 |  | DP86 | 3
 |  | AV14 | 3
 |  | KF87 | 3
 |  | UV61 | 3
 |  | TV19 | 3
 |  | EC83 | 3
 |  | VF73 | 3
 |  | TL94 | 3
 |  | JW30 | 3
 |  | AU39 | 3
 |  | OR49 | 3
 |  | SF51 | 3
 |  | BI85 | 3
 |  | JF15 | 3
 |  | SQ54 | 3
 |  | RT69 | 3
 |  | OC22 | 3
 |  | RY83 | 3
 |  | NP60 | 3
 |  | [NAME] | 3
 |  | IC96 | 3
 |  | PT78 | 3
 |  | OV28 | 3
 |  | XS29 | 3
 |  | GR54 | 3
 |  | KI25 | 3
 |  | UM60 | 3
 |  | JR57 | 3
 |  | NE37 | 3
 |  | UI57 | 3
 |  | XO14 | 3
 |  | SQ74 | 3
 |  | VB66 | 3
 |  | WZ73 | 3
 |  | UV69 | 3
 |  | ZB84 | 3
 |  | [NAME] | 3
 |  | JV35 | 3
 |  | RA49 | 3
 |  | OL10 | 3
 |  | FT89 | 3
 |  | EN27 | 3
 |  | KZ91 | 3
 |  | OT88 | 3
 |  | UX54 | 3
 |  | AE84 | 3
 |  | CT80 | 3
 |  | VP66 | 3
 |  | FT40 | 3
 |  | BP57 | 3
 |  | RW35 | 3
 |  | JZ35 | 3
 |  | AR41 | 3
 |  | OP22 | 3
 |  | ZG51 | 3
 |  | EN22 | 3
 |  | ZI60 | 3
 |  | ZU24 | 3
 |  | UG36 | 3
 |  | RZ86 | 3
 |  | MC78 | 3
 |  | SP38 | 3
 |  | ZH87 | 3
 |  | QQ71 | 3
 |  | HY97 | 3
 |  | JL72 | 3
 |  | UL63 | 3
 |  | FS21 | 3
 |  | VT99 | 3
 |  | IH75 | 3
 |  | AU14 | 3
 |  | TX38 | 3
 |  | AC77 | 3
 |  | QT86 | 3
 |  | ZI66 | 3
 |  | RV26 | 3
 |  | DH84 | 3
 |  | OW93 | 3
 |  | UT27 | 3
 |  | OI97 | 3
 |  | PS55 | 3
 |  | GT99 | 3
 |  | XL73 | 3
 |  | AK63 | 3
 |  | SK12 | 3
 |  | JF59 | 3
 |  | XU34 | 3
 |  | MA87 | 3
 |  | MQ56 | 3
 |  | VQ41 | 3
 |  | IN25 | 3
 |  | PD67 | 3
 |  | KL78 | 3
 |  | DF17 | 3
 |  | RB71 | 3
 |  | OZ64 | 3
 |  | AY69 | 3
 |  | YO79 | 3
 |  | CD31 | 3
 |  | NE40 | 3
 |  | FJ21 | 3
 |  | QI91 | 3
 |  | KD47 | 3
 |  | VZ33 | 3
 |  | CD42 | 3
 |  | ZA12 | 3
 |  | KS62 | 3
 |  | RL67 | 3
 |  | IT91 | 3
 |  | EQ54 | 3
 |  | ND60 | 3
 |  | LL31 | 3
 |  | RC63 | 3
 |  | DM98 | 3
 |  | RW81 | 3
 |  | MZ15 | 3
 |  | TP94 | 3
 |  | AC63 | 3
 |  | KO48 | 3
 |  | OD25 | 3
 |  | RA93 | 3
 |  | QU51 | 3
 |  | YC59 | 3
 |  | [NAME] | 3
 |  | GU80 | 3
 |  | ZY92 | 3
 |  | MR89 | 3
 |  | TF80 | 3
 |  | OT81 | 3
 |  | HR82 | 3
 |  | DZ10 | 3
 |  | AH33 | 3
 |  | EH71 | 3
 |  | RB72 | 3
 |  | RC11 | 3
 |  | XR11 | 3
 |  | CT47 | 3
 |  | GE15 | 3
 |  | JP53 | 3
 |  | SV68 | 3
 |  | RO13 | 3
 |  | KB62 | 3
 |  | RV63 | 3
 |  | RF45 | 3
 |  | TU12 | 3
 |  | MT38 | 3
 |  | CO81 | 3
 |  | HS39 | 3
 |  | RK81 | 3
 |  | KH78 | 3
 |  | BY89 | 3
 |  | QY72 | 3
 |  | FR98 | 3
 |  | YB54 | 3
 |  | LW86 | 3
 |  | IS26 | 3
 |  | KY82 | 3
 |  | AS35 | 3
 |  | IC45 | 3
 |  | QO28 | 3
 |  | YY60 | 3
 |  | QL13 | 3
 |  | DU74 | 3
 |  | PS10 | 3
 |  | VW39 | 3
 |  | IK40 | 3
 |  | VO45 | 3
 |  | FK45 | 3
 |  | HK34 | 3
 |  | CO85 | 3
 |  | LK20 | 3
 |  | YE39 | 3
 |  | YW77 | 3
 |  | OD52 | 3
 |  | IB34 | 3
 |  | XU91 | 3
 |  | AJ79 | 3
 |  | BL88 | 3
 |  | IU58 | 3
 |  | MV89 | 3
 |  | RI25 | 3
 |  | GA32 | 3
 |  | PD21 | 3
 |  | BT91 | 3
 |  | KY48 | 3
 |  | MZ32 | 3
 |  | CD73 | 3
 |  | QJ38 | 3
 |  | ID87 | 3
 |  | PD93 | 3
 |  | WY53 | 3
 |  | UF27 | 3
 |  | [NAME] | 3
 |  | BT59 | 3
 |  | [NAME] | 3
 |  | AC52 | 3
 |  | XV12 | 3
 |  | PB79 | 3
 |  | EJ78 | 3
 |  | RH84 | 3
 |  | IP73 | 3
 |  | OI87 | 3
 |  | YW42 | 3
 |  | CN98 | 3
 |  | BP71 | 3
 |  | GE12 | 3
 |  | NZ44 | 3
 |  | Row Labels | 3
 |  | [NAME] | 3
 |  | [NAME] | 3
 |  | ZV15 | 3
 |  | TW56 | 3
 |  | ZH45 | 3
 |  | DH41 | 2
 |  | [NAME] | 2
 |  | CE35 | 2
 |  | LA26 | 2
 |  | NO63 | 2
 |  | GT97 | 2
 |  | QD44 | 2
 |  | ST27 | 2
 |  | LD79 | 2
 |  | DJ84 | 2
 |  | EQ68 | 2
 |  | XK65 | 2
 |  | UC72 | 2
 |  | SQ49 | 2
 |  | EM71 | 2
 |  | CO67 | 2
 |  | QD27 | 2
 |  | PB85 | 2
 |  | DW40 | 2
 |  | DI88 | 2
 |  | JJ99 | 2
 |  | TS29 | 2
 |  | RC18 | 2
 |  | JC13 | 2
 |  | NG33 | 2
 |  | PD73 | 2
 |  | PL62 | 2
 |  | QT16 | 2
 |  | HZ51 | 2
 |  | QZ12 | 2
 |  | XO26 | 2
 |  | FF60 | 2
 |  | TE59 | 2
 |  | GY12 | 2
 |  | VX39 | 2
 |  | PP35 | 2
 |  | EW16 | 2
 |  | WV32 | 2
 |  | WU96 | 2
 |  | YH14 | 2
 |  | BV74 | 2
 |  | QB57 | 2
 |  | VF95 | 2
 |  | XS80 | 2
 |  | QV78 | 2
 |  | PM99 | 2
 |  | FQ45 | 2
 |  | KN28 | 2
 |  | AS31 | 2
 |  | MC50 | 2
 |  | BQ81 | 2
 |  | VI73 | 2
 |  | ZM66 | 2
 |  | EC52 | 2
 |  | FU45 | 2
 |  | MG27 | 2
 |  | [NAME] | 2
 |  | CG36 | 2
 |  | OA17 | 2
 |  | SS18 | 2
 |  | UA28 | 2
 |  | FW44 | 2
 |  | VT55 | 2
 |  | EC63 | 2
 |  | YR51 | 2
 |  | NP29 | 2
 |  | NX97 | 2
 |  | WB75 | 2
 |  | ZU12 | 2
 |  | SA94 | 2
 |  | KL19 | 2
 |  | SM67 | 2
 |  | ED22 | 2
 |  | AK81 | 2
 |  | PS49 | 2
 |  | NN66 | 2
 |  | SM16 | 2
 |  | HS26 | 2
 |  | TC45 | 2
 |  | BI71 | 2
 |  | UH77 | 2
 |  | AA21 | 2
 |  | GH86 | 2
 |  | VF61 | 2
 |  | VA98 | 2
 |  | BP66 | 2
 |  | EU81 | 2
 |  | UK20 | 2
 |  | NB80 | 2
 |  | GC14 | 2
 |  | RO84 | 2
 |  | VR36 | 2
 |  | TJ91 | 2
 |  | DC65 | 2
 |  | JB21 | 2
 |  | IE46 | 2
 |  | XI78 | 2
 |  | MD80 | 2
 |  | FM86 | 2
 |  | RL38 | 2
 |  | RQ41 | 2
 |  | TQ83 | 2
 |  | NE44 | 2
 |  | AI20 | 2
 |  | IE83 | 2
 |  | WN10 | 2
 |  | IZ60 | 2
 |  | YM82 | 2
 |  | OH92 | 2
 |  | QK63 | 2
 |  | PR24 | 2
 |  | OL79 | 2
 |  | JE11 | 2
 |  | XX46 | 2
 |  | QY33 | 2
 |  | DG65 | 2
 |  | NI57 | 2
 |  | TN22 | 2
 |  | CX54 | 2
 |  | [NAME] | 2
 |  | DO38 | 2
 |  | QN27 | 2
 |  | LS77 | 2
 |  | AQ25 | 2
 |  | ZH72 | 2
 |  | ZC84 | 2
 |  | XS52 | 2
 |  | BN92 | 2
 |  | OX54 | 2
 |  | SV13 | 2
 |  | LP73 | 2
 |  | NG98 | 2
 |  | CN93 | 2
 |  | IR64 | 2
 |  | [NAME] | 2
 |  | YE99 | 2
 |  | HF22 | 2
 |  | RR86 | 2
 |  | US91 | 2
 |  | YS81 | 2
 |  | XF97 | 2
 |  | RW29 | 2
 |  | LF34 | 2
 |  | UV11 | 2
 |  | LF91 | 2
 |  | SB96 | 2
 |  | NI43 | 2
 |  | NU66 | 2
 |  | NO21 | 2
 |  | TD12 | 2
 |  | [NAME] | 2
 |  | GF12 | 2
 |  | MQ39 | 2
 |  | MQ86 | 2
 |  | GE94 | 2
 |  | UM62 | 2
 |  | DO23 | 2
 |  | JS34 | 2
 |  | VH12 | 2
 |  | DT14 | 2
 |  | QD86 | 2
 |  | RG92 | 2
 |  | MA41 | 2
 |  | GH37 | 2
 |  | CZ72 | 2
 |  | AH93 | 2
 |  | NE30 | 2
 |  | IC24 | 2
 |  | MK63 | 2
 |  | QG35 | 2
 |  | QC80 | 2
 |  | TN40 | 2
 |  | RT56 | 2
 |  | WV83 | 2
 |  | PK78 | 2
 |  | SX57 | 2
 |  | RO48 | 2
 |  | HP64 | 2
 |  | TC55 | 2
 |  | [NAME] | 2
 |  | OF93 | 2
 |  | FZ23 | 2
 |  | QG48 | 2
 |  | KN77 | 2
 |  | KE13 | 2
 |  | JH43 | 2
 |  | [NAME] | 2
 |  | HU39 | 2
 |  | DT87 | 2
 |  | UL49 | 2
 |  | PF83 | 2
 |  | EY21 | 2
 |  | KN50 | 2
 |  | PP45 | 2
 |  | HZ32 | 2
 |  | HJ14 | 2
 |  | AI55 | 2
 |  | TV25 | 2
 |  | DJ16 | 2
 |  | CZ98 | 2
 |  | [NAME] | 2
 |  | KP97 | 2
 |  | XB10 | 2
 |  | FR62 | 2
 |  | RR31 | 2
 |  | NX69 | 2
 |  | HX89 | 2
 |  | AL26 | 2
 |  | OJ84 | 2
 |  | KN38 | 2
 |  | ON19 | 2
 |  | RV41 | 2
 |  | KN16 | 2
 |  | OY59 | 2
 |  | EU65 | 2
 |  | GY56 | 2
 |  | WI27 | 2
 |  | WX39 | 2
 |  | KN24 | 2
 |  | CQ20 | 2
 |  | CH97 | 2
 |  | XA33 | 2
 |  | DS99 | 2
 |  | BM58 | 2
 |  | IJ54 | 2
 |  | [NAME] | 2
 |  | WM51 | 2
 |  | RG72 | 2
 |  | QE56 | 2
 |  | IS98 | 2
 |  | JH11 | 2
 |  | SG16 | 2
 |  | PP31 | 2
 |  | FF13 | 2
 |  | YZ70 | 2
 |  | VO34 | 2
 |  | WB72 | 2
 |  | WX29 | 2
 |  | YR71 | 2
 |  | JF76 | 2
 |  | DB14 | 2
 |  | UA92 | 2
 |  | YW28 | 2
 |  | WK37 | 2
 |  | WV56 | 2
 |  | AS82 | 2
 |  | ON64 | 2
 |  | ZU97 | 2
 |  | AO77 | 2
 |  | QP41 | 2
 |  | YZ62 | 2
 |  | WJ76 | 2
 |  | IU13 | 2
 |  | QJ49 | 2
 |  | NA28 | 2
 |  | RO86 | 2
 |  | MV79 | 2
 |  | BF61 | 2
 |  | FS74 | 2
 |  | QB58 | 2
 |  | EA50 | 2
 |  | EM69 | 2
 |  | HV62 | 2
 |  | YW90 | 2
 |  | SH28 | 2
 |  | AP63 | 2
 |  | QU29 | 2
 |  | BT14 | 2
 |  | DS25 | 2
 |  | UG88 | 2
 |  | AQ35 | 2
 |  | HD53 | 2
 |  | PV76 | 2
 |  | IU95 | 2
 |  | IV25 | 2
 |  | HA21 | 2
 |  | VX43 | 2
 |  | VX97 | 2
 |  | JN82 | 2
 |  | SY52 | 2
 |  | FE75 | 2
 |  | PI38 | 2
 |  | VA66 | 2
 |  | QE81 | 2
 |  | XY81 | 2
 |  | VR11 | 2
 |  | IF82 | 2
 |  | PD17 | 2
 |  | OV51 | 2
 |  | UY64 | 1
 |  | BQ77 | 1
 |  | WS92 | 1
 |  | PI70 | 1
 |  | JX20 | 1
 |  | XF49 | 1
 |  | EQ99 | 1
 |  | [NAME] | 1
 |  | ML81 | 1
 |  | GY40 | 1
 |  | UW94 | 1
 |  | HC71 | 1
 |  | AU40 | 1
 |  | RE33 | 1
 |  | ZF54 | 1
 |  | LM87 | 1
 |  | FO46 | 1
 |  | RF30 | 1
 |  | FJ31 | 1
 |  | YZ77 | 1
 |  | LT52 | 1
 |  | OX67 | 1
 |  | NN97 | 1
 |  | GH71 | 1
 |  | ZE41 | 1
 |  | ZO73 | 1
 |  | YE52 | 1
 |  | AF72 | 1
 |  | HQ42 | 1
 |  | YW63 | 1
 |  | NO33 | 1
 |  | IS25 | 1
 |  | EN45 | 1
 |  | ZL16 | 1
 |  | WC79 | 1
 |  | XV49 | 1
 |  | YJ21 | 1
 |  | AF79 | 1
 |  | HW28 | 1
 |  | LO24 | 1
 |  | RO40 | 1
 |  | JE59 | 1
 |  | PF28 | 1
 |  | ZJ67 | 1
 |  | ZA41 | 1
 |  | DG62 | 1
 |  | NJ80 | 1
 |  | WY38 | 1
 |  | DX27 | 1
 |  | TG52 | 1
 |  | [NAME] | 1
 |  | SA16 | 1
 |  | [NAME] | 1
 |  | FF42 | 1
 |  | QB27 | 1
 |  | SK48 | 1
 |  | QE11 | 1
 |  | RC59 | 1
 |  | FZ55 | 1
 |  | FW89 | 1
 |  | SN16 | 1
 |  | DA78 | 1
 |  | TG82 | 1
 |  | WH85 | 1
 |  | SR70 | 1
 |  | JD50 | 1
 |  | DA42 | 1
 |  | ZC19 | 1
 |  | TV82 | 1
 |  | OS20 | 1
 |  | GC44 | 1
 |  | AE28 | 1
 |  | CS62 | 1
 |  | PH87 | 1
 |  | GB90 | 1
 |  | GL84 | 1
 |  | NW67 | 1
 |  | PC61 | 1
 |  | EE13 | 1
 |  | KD41 | 1
 |  | MO10 | 1
 |  | CK31 | 1
 |  | UF90 | 1
 |  | RA29 | 1
 |  | TY33 | 1
 |  | HG93 | 1
 |  | YW67 | 1
 |  | BP75 | 1
 |  | AF56 | 1
 |  | CX55 | 1
 |  | PL67 | 1
 |  | OT77 | 1
 |  | WZ46 | 1
 |  | ZA87 | 1
 |  | UV10 | 1
 |  | GS58 | 1
 |  | PT74 | 1
 |  | AJ28 | 1
 |  | QC22 | 1