View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sean[_9_] Sean[_9_] is offline
external usenet poster
 
Posts: 6
Default Counting numbers and letters

I'm looking for a script that will count how many times a number or letter
occurs. It would be beneficial if it could give me a total of all the
numbers 0-9 and all the letters A-Z. For instance...
If I set my cells up like such...
8A-1983
4A-1988
4A-1990
etc...

I want the script to search the entire active sheet or selection and return
a new sheet with something like...

0-1
1-3
2-
3-1
4-2
5-
6-
7-
8-4
9-4

a-3
b-
c-
....
Leaving the value for any zeros as a blank next to the owner.
Thanks in advance.
--
______________________________
Thank you, Sean
Artist/Production Manager
Please visit us at www.oatesflag.com
502-267-8200
502-267-8246 fax