View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Basenji Basenji is offline
external usenet poster
 
Posts: 40
Default 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.