maratikus

I just saw this query,
Actually you can use function 'large'

so you insert one column at the left and 51 (1/10 of the maximum rows +1) rows at the top of your data

A2:A51 = 1 to 50
b1 = =COUNT(B52:B7001),
b2 = =IF($A2<B$1/10,LARGE(B$52:B$597,$A2),"")
drag this to row 51
drag b1:b51 all the way to the right