| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Formating Letters to Numbers while Displaying Letters | Excel Worksheet Functions | |||
| Columns now numbers rather than letters how do i get letters back | Excel Discussion (Misc queries) | |||
| Counting how many numbers and letters appear in a particular row | Excel Discussion (Misc queries) | |||
| Counting occurance of letters or numbers | Excel Discussion (Misc queries) | |||
| Counting groups of exact case numbers w/letters in them. | Excel Discussion (Misc queries) | |||
![Sean[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
