| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting numbers with a letter attached in excel
Hi all,
Sheet 1 Column A1 to A10 contains user input of say 10S 5S 6A 7B 25C 7C the letter after the number gives the number a unique identifier. How do I count these up so they become a number only on Sheet 2 in a column Bats Total 7 Cricket Balls 32 Antenna 6 Seats 15 Thanks for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting groups of exact numbers in a huge list (column) | Excel Discussion (Misc queries) | |||
| Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| FedEx tracking numbers in Excel | Excel Discussion (Misc queries) | |||
| How do I change format of page numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
| Can Excel evaluate a series of numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
