I put the following in K8 of the 'Goal' sheet, dragged the fill handle over to AH8 then down to AH30. I got the same values as were previously manually placed in that range, so I used the same formula on the 'Dept_0' and 'Dept_1' sheets and got results that seemed reasonable.
Formula:
=IFERROR(INDEX(Master!H$4:H$500,AGGREGATE(15,6,(ROW($4:$500)-3)/((Master!$A$4:$A$500=$B8)*(Master!$D$4:$D$500=$G8)),1)),"")
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
You're awesome! I plugged it in and it seems to work perfectly!Originally Posted by JeteMc
I put the following in K8 of the 'Goal' sheet, dragged the fill handle over to AH8 then down to AH30. I got the same values as were previously manually placed in that range, so I used the same formula on the 'Dept_0' and 'Dept_1' sheets and got results that seemed reasonable.
Formula:=IFERROR(INDEX(Master!H$4:H$500,AGGREGATE(15,6,(ROW($4:$500)-3)/((Master!$A$4:$A$500=$B8)*(Master!$D$4:$D$500=$G8)),1)),"")
Let us know if you have any questions.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Jpidge20 
Register To Reply
Bookmarks