Rate cards

[MatthewPaul]

Hi there, I'm looking at building a tender document that houses multiple vendor responses with drop down boxes.
I've been doing this for a while but what I would really like is to have a drop down box in a summary tab, where I can select either, the lowest price across all vendors or individual vendor pricing. I would also like one that removes the highest pricing as this may sometime skew out my results when running analytics on the tender.

As an example:

I might have 10 items I would like quoted and either a range of quantities or only one.
I will have 5 suppliers quoting the items.

In my summary tab, I would have:
1. Total minimum cost (mostly unit cost)
2. Average unit cost
3. Variance between lowest and average
4. Variance between lowest and average

What I would like is a drop down box where I can choose to exclude the highest value across the 10 items if I believe the costs are too high.

I hope I have explained myself and I am really looking forward to your response.

Thank you very much in advanced.