If you paste this into I5 of your grid:
=IF(AND(I$4>VLOOKUP($H5,$B
You will need to change the pivot table to show the Destination on each row.
In Field Settings, Layout & Print tab, check Repeat Item Labels
John
=IF(SUMPRODUCT(($A$5:$A$94=$H5)*($C$5:$C$94<=I$4)*($D$5:$D$94>=I$4)*($E$5:$E$94))=0,"",SUMPRODUCT(($A$5:$A$94=$H5)*($C$5:$C$94<=I$4)*($D$5:$D$94>=I$4)*($E$5:$E$94)))
ExpertEx-1.xls
{Side note: using commas inside of SUMPRODUCT function - rather than multiplication - operates faster}
Title | # Comments | Views | Activity |
---|---|---|---|
In Excel 2007, how do I need to correct this ampersand formula so it works? | 2 | 14 | |
File size limit in SharePoint 2010 | 3 | 15 | |
Excel split data and output all combinations. | 2 | 20 | |
Populate data based on a criteria | 2 | 16 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!