| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count based on single number in string
The column has data like this A1, 7*4*9; A2, 1*4; A3, 9*10. The numbers vary
as well as the length. The numbers are always whole numbers and never negative. I need to count the number of cells that have a number less than six immediately to the right of the first asterink from the left. The asterink has nothing to do with multiplication. I tried to modify a formula from my previous question but struck out. Thank you for your assistance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count based on single number | Excel Worksheet Functions | |||
| How to count the number of occurrence within string? | Excel Discussion (Misc queries) | |||
| Convert YYYY, MM, and DD as a single number string | Excel Discussion (Misc queries) | |||
| count number of letters in a string | Excel Worksheet Functions | |||
| count number of occurences within a string | Excel Worksheet Functions | |||
Threaded Mode
