Function help

A

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
 
R

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
Click to expand...

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

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


--ron
 
J

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
 
J

Jim May

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