Function help
 

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

On 18 Dec 2004 12:32:41 -0800, (Ahmad) wrote:

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

One way:

Put this in cell C2:

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

and copy down to C11.


In article ,
(Ahmad) wrote:

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

Try the following...

C2, copied down:

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

Hope this helps!

In article ,
(Ahmad) wrote:

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

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

"Ahmad" wrote in message
om...
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

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

"Jim May" wrote in message
news:h%0xd.7423$jn.6873@lakeread06...
Assuming your data below is now in A1:C10..
Overwrite and enter In Cell C1 =COUNTIF($B$1:B1,"<"&B1) and Copy down.
HTH

"Ahmad" wrote in message
om...
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