Excel - Calculate the occurence of an alphabet

February 2017



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


Published by aakai1056. Latest update on May 30, 2011 at 07:19 AM by aakai1056.
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 (ccm.net).