How do we calculate the occurence od a particular alphabet in one complete row.
For example: P is mentioned 25 times in 30 days, how to automatically retrieve the values of P.
If your data is from column 2 to 30, take 'range' as $A2:$AD2
then put in AE2 as =countif($A2:$AD2 ,"=P") and copy it to below cells in that column
Thanks to Excelguru
for this tip
Published by aakai1056
Latest update on May 30, 2011 at 07:19 AM by aakai1056.