View Single Post
  #1   Report Post  
nyc_doc
 
Posts: n/a
Default How to count a range of values in a single cell?

This should be SO simple, but I just can't figure it out!
I've got a column in which each cell has a different list of numbers
separated by commas. I need to count how many numbers in a cell are greater
than or equal to 15:

4,14,16,15,15.3 -- 3
10,10.5,14.9 -- 0
0 -- 0
19, 15.1 -- 2

Anybody got any ideas??? Thanks for your help!