D2 =LARGE($C$2:$C$100,ROWS($C$2:$C2))
E2 =INDEX(A:A,$I2)
F2 =IF(I2>2,INDEX($B:$B,I2-1),"")
G2 =INDEX(B:B,$I2)
H2 =INDEX($B:$B,I2+1)
I2 =AGGREGATE(15,6,ROW($A$2:$A$100)/($C$2:$C$100=$D2),COUNTIF($D$2:$D2,$D2))
Hi, i have this code in excel. Can someone please help me convert it so it works in open office? Would be very appriciated. Thank you.
E2 =INDEX(A:A,$I2)
F2 =IF(I2>2,INDEX($B:$B,I2-1),"")
G2 =INDEX(B:B,$I2)
H2 =INDEX($B:$B,I2+1)
I2 =AGGREGATE(15,6,ROW($A$2:$A$100)/($C$2:$C$100=$D2),COUNTIF($D$2:$D2,$D2))
Hi, i have this code in excel. Can someone please help me convert it so it works in open office? Would be very appriciated. Thank you.