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.

Sony Vaio Z Canvas release date, price and specs: Another Surface Pro rival but for the US

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

Steve Albini's notorious email is now a punchy music video

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