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 Topic

Post Reply Login

Counting Case-sensitive Values Within A Range Of Cells

Rate this:

(3/5 from 1 vote)

	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

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

counting case sensitive

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 pooja_dubey12 on 31 Mar 2008

Displaying page 1 of 1

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