Hi,

Assuming you are starting in row 1 put this in c1 and drag down to solve for
each value in Column A

=COUNT(IF(A1$B$1:$B$10,$B$1:$B$10,FALSE))

It's an array formula so coommit with Ctrl+Shift+Enter NOT just enter.

Mike

"Rocky4460" wrote:

Can anyone suggest a formula for this?
Basically, I'm trying to find out how many times does a number on the data 1
column exceed the numbers on the data 2 column.

Data 1 Data 2 Value
4 3
5 18
10 1
4 2

The result should say for the 'value' column 3, since 4 3,1,2 but less than
18
similiarly for 5, the result should be 3 and so on.

Thanks, I tried the countif method, but does not help.