Hi,
I want to achieve the following:
A1=RIGHT($Data.B3,6)
A2=RIGHT($Data.B5,6)
A3=RIGHT($Data.B7,6)
A4=RIGHT($Data.B9,6)
A5=RIGHT($Data.B11,6)
A6=RIGHT($Data.B13,6)
I used to be able to do this by highlighting the first 2 cells and dragging from the corner down.
However I am now getting the following result which I can’t understand;
A1=RIGHT($Data.B3,6)
A2=RIGHT($Data.B5,6)
A3=RIGHT($Data.B5,6)
A4=RIGHT($Data.B7,6)
A5=RIGHT($Data.B7,6)
A6=RIGHT($Data.B9,6)
Is they a way to fix this?
By the way, MS Excel gives the same results. Hence, spreadsheets think differently. 
what is confusing me the most is it worked so far in another before doing this
IF you fill down
B3
B5
you will get
B7
B9
etc.
But if you fill down
=B3
=B5
you will get
=B5 (that is; B3 augmented by 2, that is the row distance)
=B7 (that is; B5 augmented by 2)
=B7 (that is; B5 augmented by 2)
Don’t know if this is the intended behavior.
So, you can write:
A1: =RIGHT($Data.B3,6)
Select A1 and A2 (empty), fill down, select the range and sort.
Not for me.
I would organize the data properly so each single row defines one record of data.
Anyway,
=RIGHT(OFFSET($B$3;ROW()*2;0);6) should do the job.