Sort of the values with its dates.

[thilag]

Hello Friends

Please find the attached 2010 version file <high and lows 240415.xlsx>.

I want to sort the values with its date and plotting in the light yellow and green color cells.

thanks

thilag

[sandy666]

Use Data --> Sort, or I misunderstood

[samba_ravi]

D2=SMALL(INDEX(($B$2:$B$81<>E2)*10^10+($A$2:$A$81),0),COUNTIF(E$2:E2,E2))
E2=SMALL($B$2:$B$81,ROW(A1))
G2=LARGE(INDEX(($B$2:$B$81'H2)*($A$2:$A$81),0),COUNTIF(H$2:H2,H2))
H2=LARGE($B$2:$B$81,ROW(D1))
Try this and copy towards down

[thilag]

Dear Siva

G2 cell formula not working. Apart from it everything fine.

thanks

thilag

[samba_ravi]

Sorry some typing error
G2=LARGE(INDEX(($B$2:$B$81=H2)*($A$2:$A$81),0),COUNTIF(H$2:H2,H2))
Try this

[azumi]

Another try....................

[thilag]

Dear Siva and Dear azumi

Thanks for both of you. Your formulas working fine.

I will use the Siva's non array formula.

thanks again

thilag