Results 1 to 10 of 12

Thread: Two Column Dates to arrange in a single column

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Two Column Dates to arrange in a single column

    Sheet-1: I have dates in B5:B14 and some values in c5:c14 (and entries goes on for 1 year)
    Likewise,
    Sheet2: I have dates in E5:E14 and some values in F5:F14 (and entries goes on for 1 year)
    Sheet-3: I need a result table, where all dates should align in a single column H and its equivalent values in I column
    I tried, Offset, lookup, index etc, but i failed.
    Thus i seek your help.
    Sheet-Sample is attached
    Thank U
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •