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!

Try to do it in two steps:

1. Use Data Text to Columns... to take each string of numbers and convert
it into a row of single numbers.

2. Use COUNTIF on each row based upon your criteria
--
Gary's Student


"nyc_doc" wrote:

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!

Thanks "Gary's Student". I did the same thing in a more round about way. I
copied the string from the cell to a text file and imported back to get the
same result. Learnt something useful from this. Thanks both of you


"Gary's Student" wrote:

Try to do it in two steps:

1. Use Data Text to Columns... to take each string of numbers and convert
it into a row of single numbers.

2. Use COUNTIF on each row based upon your criteria
--
Gary's Student


"nyc_doc" wrote:

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!

Thanks GS- that's certainly simple... anyway to do this without dividing the
numbers into individual columns? there's gotta be some fun, fancy formula
that can separate out each number....


"Gary's Student" wrote:

Try to do it in two steps:

1. Use Data Text to Columns... to take each string of numbers and convert
it into a row of single numbers.

2. Use COUNTIF on each row based upon your criteria
--
Gary's Student


"nyc_doc" wrote:

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!