Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom

It's free to register, to post a question or to start / join a discussion

View Forum Rules | Contact Forum Editor

 

Sort Columns of Letters Excel 2007

tonyq

Likes # 0

Posted November 25, 2012 at 2:20PM

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.

Like this post
Zak

Likes # 0

Posted November 25, 2012 at 2:24PM

Use this formula in your chosen cell say C1:

=COUNTIF(A1:A26,"A")

then for C2

=COUNTIF(A1:A26,"B")

and so on.

Like this post
Woolwell

Likes # 0

Posted November 25, 2012 at 3:09PM

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?

Like this post
tonyq

Likes # 0

Posted November 25, 2012 at 3:54PM

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.

Like this post

Reply to this topic

This thread has been locked.



Check out PC Advisor's other tech forums

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story. Both your name and the recipient's name and address will not be used for any other purpose.