ExcelBanter - View Single Post

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