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
|