Trying to get the proper results to show. SHEET ATTACHED.
Trying to get the proper results to show. SHEET ATTACHED.
This is how I would do it. Only one array formula in a helper column that gives the row no and then INDEX for all other columns. This will make it faster and easier to maintain.
I converted your data into an Excel List, it will expand automatically (including the formulas in it). By using the Excel list the ranges for the array formula is no larger than they have to be. This way it will run much, much faster.
Check the array formula if I managed to get your new criteria in there.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Another approach, without an array formula...
on DATA sheet, in a helper column (I used AE), copy this down as far as you need...
=IF(AND(A2=MASTER!$E$2,E2=MASTER!$G$2,X2>=MASTER!$H$2),1+AE1,AE1)
Then in MASTER D4, copied down and across, use this...
=iferror(INDEX(DATA!$A$1:$AD$20,MATCH(ROW($A1),DATA!$AE$1:$AE$20,0),MATCH(MASTER!D$3,DATA!$A$1:$AD$1,0)),"")
NOTE: Make sure that all of your headings match exactly, else the match wont work
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks