Sort Columns of Letters Excel 2007

  tonyq 14:20 25 Nov 2012
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 2012

Use this formula in your chosen cell say C1:

=COUNTIF(A1:A26,"A")

then for C2

=COUNTIF(A1:A26,"B")

and so on.

  tonyq 15:54 25 Nov 2012

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.

Elsewhere on IDG sites

Google Home Hub review

This graphic novel uses AR to blur the lines between cartoon, comic and video game

How to watch Apple's October 2018 iPad launch

Comment d├ęsinstaller des applications sur un Mac ?