| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count numbers that start with 1
Hi,
Is it possible to search a spreadsheet and count the numbers that only start with the number 1? And then also count how many cells it searched in order to obtain that value? For Example: 10 2,100 1,500,100 10,150,280 317 Cells with the number 1 = 3 Total cells looked at = 5 Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Number of Days after a Start Date | Excel Discussion (Misc queries) | |||
| Count consecutive cells then start over | Excel Worksheet Functions | |||
| How to count # of dates that fall between a start and end date. | Excel Programming | |||
| Looking to add a leading 0 @ start of numbers | Excel Discussion (Misc queries) | |||
| Can I remove Row Numbers? Or have the Row Numbers start on the Ro | Excel Discussion (Misc queries) | |||
Threaded Mode
