Drag Cell with fixed Interval

[kmaient]

Hi Experts,

I am not good enough in English!


I am beginner level excel user and I surprised to there is a lot formula to ease data job! Currently I am facing this,

I want to drag a data by formula from another sheet, where data avail with serial row; But, those data store in a new sheet with a regular interval,

Please see the attached file.

Thanking Advance for your kind help.


Regards

K. M.

[Glenn Kennedy]

Hi there!! How is Dhaka? Is the traffic still as crazy as ever?

One way:

=IF(1+MOD((ROWS($2:2)-1),4)=1,INDEX(OBC!$A$7:$A$10,1+MOD((ROWS($2:2)-1),4)),INDEX(OBC!$B$1:$B$3,MOD((ROWS($2:2)-1),4)))

[Estevaoba]

If Glenn allows me, I would modify his formula just a bit as follows:

Please Login or Register  to view this content.

This will list all values from column A in the OBC sheet.

[kmaient]

Oh! you visit Dhaka!

Yes! it is still now, but there are more flyover make it faster than before!

Thank you very much for your support. It's Great!

[Glenn Kennedy]

Yes. My last visit was in 2013, I think. I was there about 5 times in total. Mostly in Dhaka, but also in the lovely countryside near Khulna.

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.