| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count of FIRST Digit
Hi Everyone,
I have a Row of 100 Numbers that Range from 1 to 1000. What I would like to do is to Count How Many Times the FIRST Digit 1,2,3,4,5,6,7,8 & 9 Appear in Each Row Please. I know that I can Use Left(B10) for Example to get the FIRST Digit But How do you get it to do the Count Please. Thanks in Advance. All the Best. Paul *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional format on first & last digit on 3 digit cell data | New Users to Excel | |||
| Convert 2 digit month to 4 digit years and months | Excel Worksheet Functions | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
![Paul Black[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
