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

Counting case sensitive

Excel Help for Counting Case Sensitive in Automating Data Analysis Tasks


Forum TopicLogin

Counting Case Sensitive

Rate this:
(3/5 from 1 vote)
Confusedhi,

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
 
View Full Post

Find relevant Excel templates and add-ins for counting case sensitive in the

© Business Spreadsheets   Legal   Follow us: