 | hi,
you can try the function exact to compare the case n then count as below
| DF | =EXACT(D2,UPPER(D2)) | | gh | =EXACT(D3,UPPER(D3)) | | GH | =EXACT(D4,UPPER(D4)) | | DF | =EXACT(D5,UPPER(D5)) | | gh | =EXACT(D6,UPPER(D6)) | | GH | =EXACT(D7,UPPER(D7)) | | DF | =EXACT(D8,UPPER(D8)) | | gh | =EXACT(D9,UPPER(D9)) | | GH | =EXACT(D10,UPPER(D10)) | | DF | =EXACT(D11,UPPER(D11)) | | gh | =EXACT(D12,UPPER(D12)) | | GH | =EXACT(D13,UPPER(D13)) | | DF | =EXACT(D14,UPPER(D14)) | | gh | =EXACT(D15,UPPER(D15)) | | GH | =EXACT(D16,UPPER(D16)) | | DF | =EXACT(D17,UPPER(D17)) | | gh | =EXACT(D18,UPPER(D18)) | | GH | =EXACT(D19,UPPER(D19)) | | DF | =EXACT(D20,UPPER(D20)) | | gh | =EXACT(D21,UPPER(D21)) | | GH | =EXACT(D22,UPPER(D22)) | | Lower case | =COUNTIF(E1:E21,FALSE) | | Upper case | =COUNTIF(E1:E21,TRUE) |
| DF | =EXACT(D2,UPPER(D2)) | | gh | =EXACT(D3,UPPER(D3)) | | GH | =EXACT(D4,UPPER(D4)) | | DF | =EXACT(D5,UPPER(D5)) | | gh | =EXACT(D6,UPPER(D6)) | | GH | =EXACT(D7,UPPER(D7)) | | DF | =EXACT(D8,UPPER(D8)) | | gh | =EXACT(D9,UPPER(D9)) | | GH | =EXACT(D10,UPPER(D10)) | | DF | =EXACT(D11,UPPER(D11)) | | gh | =EXACT(D12,UPPER(D12)) | | GH | =EXACT(D13,UPPER(D13)) | | DF | =EXACT(D14,UPPER(D14)) | | gh | =EXACT(D15,UPPER(D15)) | | GH | =EXACT(D16,UPPER(D16)) | | DF | =EXACT(D17,UPPER(D17)) | | gh | =EXACT(D18,UPPER(D18)) | | GH | =EXACT(D19,UPPER(D19)) | | DF | =EXACT(D20,UPPER(D20)) | | gh | =EXACT(D21,UPPER(D21)) | | GH | =EXACT(D22,UPPER(D22)) | | Lower case | =COUNTIF(E1:E21,FALSE) | | Upper case | =COUNTIF(E1:E21,TRUE) |
PD |
| | PD |
| | Posted by pooja_dubey12 on | |