Attached is an example of a sheet I am trying use to find a low bidder by store. I have a pivot table the the vendor as the heading and the data for each vendor. To the right of the pivot table I have a formula that uses the pivot table to find the MIN in the row and return the vendor name.
Problem.
If I make a selection on the page drop down the formula's I added stay static.
Bookmarks