Home > Forum Home > Automating Data Analysis Tasks > Counting case-sensitive values within a range of cells Share

Counting case-sensitive values within a range of cells

Excel Help for Counting Case-sensitive Values Within A Range Of Cells in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Counting Case-sensitive Values Within A Range Of Cells

Rate this:
(3/5 from 1 vote)
ConfusedHow 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 on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
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 on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Counting case-sensitive values within a range of cells in the