Sort Columns of Letters Excel 2007

  tonyq 14:20 25 Nov 12
Locked

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 25 Nov 12

Use this formula in your chosen cell say C1:

=COUNTIF(A1:A26,"A")

then for C2

=COUNTIF(A1:A26,"B")

and so on.

  Woolwell 15:09 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 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.

Advertisement

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

Should I upgrade to Windows 10? Why upgrade to Windows 10? Is Windows 10 good? The pros and cons of!…

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

This Uplifting Animation Celebrates Team GB’s Road to Rio

How to use Apple Music in the UK: Complete guide to Apple Music's features, including new features…