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

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