Function help

[Ahmad]

dear freinds:
I have some problems with this data, how can I get the results thats
shows in results column;


YEARS DATA RESULTS
1995 100 0
1996 90 0
1997 120 2
1998 100 1
1999 150 4
2000 70 0
2001 80 1
2002 30 0
2003 150 7
2004 140 7


for example second 150 there are 7 number smallest it
thank you

 

[Ron Rosenfeld]

dear freinds:
I have some problems with this data, how can I get the results thats
shows in results column;


YEARS DATA RESULTS
1995 100 0
1996 90 0
1997 120 2
1998 100 1
1999 150 4
2000 70 0
2001 80 1
2002 30 0
2003 150 7
2004 140 7


for example second 150 there are 7 number smallest it
thank you

If your table is in A1:C11, then enter the following formula into C3, and
copy/drag down:

=COUNTIF(B2:$B$2,"<"&B2)


--ron

 

[JE McGimpsey]

One way:

Put this in cell C2:

=COUNTIF(B$2:B2,"<"&B2)

and copy down to C11.

 

[Domenic]

Try the following...

C2, copied down:

=COUNTIF($B$2:B2,"<"&B2)

Hope this helps!

 

[Jim May]

Assuming your data below is now in A1:C10..
Overwrite and enter In Cell C1 =COUNTIF($B$1:B1,"<"&B1) and Copy down.
HTH

 

[Jim May]

I missed the fact that you had a header row;
the other two guys gave you your answer,
sorry