Good afternoon to all. I'm seeking some help on a problem I cannot find a solution.
I have a workbook with two sheets.
- Sheet A is a list of project items having estimated and actuals.
- Sheet B is a sort of a highlevel project plan which i'm designing.
I would like Sheet B to be automatically updated depending on certain codes. Sheet B; Column E, Row 1 (COFP) is an example. I would like to have the list automatically populated depending on such a key.
Excel file attached.
Thanks
In Sheet A, create a key column (I did in I),
=C2&COUNTIF($C$2:$C2,C2)
copied down
Assuming you are using Excel 2007 or higher, in A4 of Sheet B (for example) copied down
=IFERROR(INDEX('Sheet A'!D$2:D$500, MATCH($E$1&ROWS($A$1:$A1),'Sheet A'!$I$2:$I$500,0)),"")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of just Enter.
In A4
and copy across to C4 and down.
Please Login or Register to view this content.
Same array formulas, you will find in G4 and M4 for other codes.
Is this what you are trying to achieve?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks