Drag a formula right one cell, reference cell jumps right 2 cells?

I need to skip reference by 1 column when I drag.

E 0 X 0 C 0 E 0 L

Should give me EXCEL

eg 2
Time out - time in for day 1, then just drag to get for other days.
H I
2-May 3-May
Time in Time Out Time in Time Out
7:51 16:25 7:33 17:06
9:32 18:12 9:16 20:00


Please help, I urgently need this

Posting a sample of your workbook will give you more chance of receiving meaningful help.

you can try something like =(A1&C1&E1) depending on where the cells are located.

Hi Mukul,

In the attached sheet I have put data as you have suggested . In sheet1 the below formula is used in cell A5 and autofilled formula to cells at right
=OFFSET(A1,0,COLUMN(A1)-COLUMN($A$1),1,1)
It fetches data from first row as I have assumed that the values start from cell A1.


In the sheet2 the formula is used in cell A6 and auto filled to cells at right and down.
=OFFSET(A2,0,COLUMN(A2)-COLUMN($A$2),1,1)

Note :You can change the reference of data but the absolute col and row reference eg.COLUMN($A$2) above should be same as the first column of data set.

Thank You Bhuvanesh.. .

I can never thank you enough for this. )

Originally Posted by Bhuvanesh

Hi Mukul,

In the attached sheet I have put data as you have suggested . In sheet1 the below formula is used in cell A5 and autofilled formula to cells at right
=OFFSET(A1,0,COLUMN(A1)-COLUMN($A$1),1,1)
It fetches data from first row as I have assumed that the values start from cell A1.


In the sheet2 the formula is used in cell A6 and auto filled to cells at right and down.
=OFFSET(A2,0,COLUMN(A2)-COLUMN($A$2),1,1)

Note :You can change the reference of data but the absolute col and row reference eg.COLUMN($A$2) above should be same as the first column of data set.