Dear VDS,
Enter the following Array Formula in cell C6 for Lower Case count and drag it down.
=SUM(IFERROR(IF(CODE(MID($B6,ROW(1:20),1))>90,1,0),0))
Enter the following formula in cell D6 for Upper case count and drag it down.
=SUM(IFERROR(IF(CODE(MID($B6,ROW(1:20),1))<=90,1,0),0))
Array...
Hi Chanthan,
Insert the following Array Formula in cell C4.
=IFERROR(INDEX($A$1:B19,IFERROR(SMALL(IF($A$14:$A$19=$D$1,ROW($A$14:$A$19),"-"),ROW()-ROW($C$3)),"-"),2),"")
Array Formulas are entered using Control + Shift + Enter instead of Enter.
Vijaykumar Shetye,
Panaji, Goa, India