+ Reply to Thread
Results 1 to 1 of 1

Formula correction for transferring selected data between sheets. IFERROR

  1. #1
    Registered User
    Join Date
    02-13-2012
    Location
    Western NSW
    MS-Off Ver
    Excel 2010
    Posts
    20

    Post Formula correction for transferring selected data between sheets. IFERROR

    Hi All,

    I have attached the Sample sheet I am having trouble with.

    What I want to do is copy entries from another sheet to this one, and also months following. I have only attached one month sheet due to being able to work the rest out once i get this one fixed.

    The forumla I'm using is this:

    =IFERROR(IF(MONTH(INDEX('PPS Monitoring'!I$2:I$521,SMALL(POS,ROW(I1))))=MONTH($I$1),INDEX('PPS Monitoring'!I$2:I$521,SMALL(POS,ROW(I1))),""),"")

    However I want the row to fill the entries in A,B & C if there are entries in D, E or F.... I had one forumal that did this but it filled the whole row not just where I wanted the data to be.

    I am very new to this and am stumbling my way through this with help, so the feedback will need to be fairly basic for me, feel free to use the preadsheet if that helps.

    Thanks in Advance
    Attached Files Attached Files
    Last edited by Danimarie; 02-15-2012 at 10:52 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1