Rank required for data

Hello All
I have a spreadsheet attached as follows
COL A =DATE
COL D =PLACE
COL E =TIME
COL I =DATA
I would like to rank the data in order as shown in col k,the ranks are in sequence except where the data is duplicated.I have left empty rows between the data foe clarity,there are no empty rows in the data.
Many thanks for help given.

i dont understand your ranking there is a joint rank 2 followed by 3 but joint rank of 4 is followed by 6
9 1
11 2
11 2
20 3
32 4
32 4
40 6

well i know how to rank it dependent on column e
1
2
2
4
5
5
7
but that has me beat

http://www.youtube.com/watch?v=rCeTG2k2T6I
Does this help you?

there are no empty rows in the data.

Try this...

Enter this array formula** in K2 and copy down as needed:

=SUM(IF(FREQUENCY(IF(E$2:E$52=E2,IF(I$2:I$52<I2,I$2:I$52)),I$2:I$52),1))+1

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.