Sort Columns of Letters Excel 2007

  tonyq 14:20 PM 25 Nov 12

Hi all, I have 3 columns of letters ranging from A to L in a spread sheet. Is there a way to tell me how many of each letters there are.

  Zak 14:24 PM 25 Nov 12

Use this formula in your chosen cell say C1:


then for C2


and so on.

  Woolwell 15:09 PM 25 Nov 12

Using a filter and selecting a letter will also tell you how many of each.

But do you want a list of the number of letters?

  tonyq 15:54 PM 25 Nov 12

I am wanting a list of the number of letters. I have managed to do it using Zak's suggestion. Thank you for your help.


This thread is now locked and can not be replied to.

How to watch Rugby World Cup 2015 online: Watch live, catch up on-demand & stream the 2015 Rugby…

1995-2015: How technology has changed the world in 20 years

How to watch Adobe Max 2015: See Adobe unveil new Creative Cloud features for Photoshop,…

Live Photo tips: How to take Live Photos on the iPhone 6s, how to view, share, edit and find Live…