• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need your help

Syed,

Here's a suggestion: You'll have to adjust the M3 references in the following formula to reflect the location where you are pasting the formula

=OFFSET($A$2,INT((ROWS($M$3:M3)-1)/2),MOD(ROWS($M$3:M3)-1,2))

See attached.
 

Attachments

  • syedali1.xlsx
    10.1 KB · Views: 0
Last edited:
eibi said:
Syed,

Here's a suggestion: You'll have to adjust the M3 references in the following formula to reflect the location where you are pasting the formula

=OFFSET($A$2,INT((ROWS($M$3:M3)-1)/2),MOD(ROWS($M$3:M3)-1,2))

See attached.
Click to expand...
Thank you
 
You must log in or register to reply here.
Back
Top