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
This document, titled « Excel - Calculate the occurence of an alphabet », is available under the Creative Commons
license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM