Trying to copy the most recent 6 (or less if not 6) from the year prior's sheet. There are some blanks.
Thanks for your help
Mike
Trying to copy the most recent 6 (or less if not 6) from the year prior's sheet. There are some blanks.
Thanks for your help
Mike
After looking at your file, Im not really sure what data you are looking at, and where you want it to go to?
As a side-note, formulas cannot "copy" anything anywhere, they only affect the cell they reside in. If you actually want to physically copy data from 1 point to another, you would need VBA.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this in B3:
=IFERROR(INDEX('2018'!$H3:$AA3,LARGE(IF('2018'!$H3:$AA3<>"", COLUMN('2018'!$H3:$AA3)),
COLUMNS(B2:$G2))-COLUMNS('2018'!$A$1:$G$1)),"")
Array formula, enter with Ctrl+Shift+Enter.
Last edited by Phuocam; 10-29-2018 at 12:55 AM.
Phuocam,
Tried it and it did not do it. Thanks for trying. I would like it to look at all entries from 2018 from b3 to aa3 and then copy the most recent in 2019 f3. Then the next most recent in e3, then d3, then c3, then finally the oldest of the 6 entries in b3.
Please see attached
B3
=IFERROR(INDEX('2018'!3:3,AGGREGATE(14,6,COLUMN('2018'!$B3:$AA3)/('2018'!$B3:$AA3>0),COLUMNS(B3:$G3))),"")
Phuocam's formula work almost the same, just range is not include until B3.
Perfect, Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks