ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   calculating letters (https://www.excelbanter.com/excel-discussion-misc-queries/160842-calculating-letters.html)

dave_laroche

calculating letters
 
I place letters in cells and I would like to calculate all the letters in a
column.

Dave

Max

calculating letters
 
One guess is that you want to count the number of times that each letter
appears in that col

Assuming source letters running in A1 down
In B1: =COUNTIF(A:A,A1)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dave_laroche" wrote:
I place letters in cells and I would like to calculate all the letters in a
column.

Dave



All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com