How can I count A lowercase and A uppercase in a range of cells Lets asay I have A lowercaase and A uppercase in arange of cells and I want to have the number of Capital A only Posted by Jessika on 11 Feb 2008
Rate this:
(
3 /5 from
1 vote)
hi, you can try the function exact to compare the case n then count as belowDF =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 31 Mar 2008