Excel - Calculate the occurence of an alphabet

December 2016



Issue


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.

Solution


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

Related :

This document entitled « Excel - Calculate the occurence of an alphabet » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.