locked
C1=A1, C2=A3 so that C3=A5, C4=A7 etc. RRS feed

  • Question

  • A1A2, A3A4, A5A6, etc. these cells have merged, how to enter C1=A1, C2=A3 in the queue, so continue to pull down C3=A5, C4=A7 etc.
    Friday, August 30, 2019 6:36 AM

Answers

  • Hi,

    Based on your description, I created a sample about your problem, please check if this will help you.

    Try this formula in C1:

    =OFFSET(A$1,ROW(A1)*2-2,)

    If my understanding is incorrect, please provide more information or a sample about this problem.

    I'm glad to help you.

    Regards,

    Emi Zhang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    • Marked as answer by PumpkinDam Monday, September 2, 2019 1:28 AM
    Friday, August 30, 2019 7:22 AM