This file contains 2 sheet Main M and Detail D.
In Sheet Detail D, When I choose Code, month of Project, it will be shown the result.
By the way, tell me how to delete the Auxiliary column in Main sheet.
This file contains 2 sheet Main M and Detail D.
In Sheet Detail D, When I choose Code, month of Project, it will be shown the result.
By the way, tell me how to delete the Auxiliary column in Main sheet.
See the attached file. I replaced all your offset formulas with INDEX/MATCH formulas and created a unique identifier in your "Aux Column" column using
=C12&"_"&COUNTIF($C$12:C12,C12)
Then, in D!C9 for example
=IFERROR(INDEX(M!$F$12:$F$19,MATCH($AI$1&"_"&ROWS($A$1:A1),M!$B$12:$B$20,0)),"")
For your data, in D9 copied across and down
=IFERROR(INDEX(M!$H$12:$NH$19, MATCH($AI$1&"_"&ROWS($A$1:A1),M!$B$12:$B$19,0),MATCH($AJ$1,M!$H$10:$NI$10,0)+COLUMNS($A$1:A$1)-1),"")
Does that work for you?
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
Sorry, how to delete Protected viewed in your file ?
I didn't protect anything. What did you want to delete?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks