Sort Columns of Letters Excel 2007

  tonyq 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 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 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 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.

Windows 10 Home vs Windows 10 Pro comparison: Here are the extra features you get in the Pro version

Why Formula-e needs to go faster

How Instagram spots trends

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message