LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
nyc_doc
 
Posts: n/a
Default Count number of values in a 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
19, 15.1, 15 --2

Anybody got any ideas??? Thanks for your help!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
How do you count number of characthers in a single cell? Joe Excel Worksheet Functions 2 February 18th 05 08:06 PM
spread the number 123.45 so each digit goes to a different cell Linda H. Excel Worksheet Functions 6 February 17th 05 07:07 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 06:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"