bidder

Hi I would like a formula that allocates 10 point to highest bidder, the second bidder get proportion of the 10 point as distance from the highest bidder, so same from bidder 3 etc. Hope the above makes sense Any help would be much appreciated Thank you

I would like help with creating a simple database in Excel. This is for a non-profit silent auction. I need two different tables/charts that have the following information: #1 "Items" - Item #, Item Name, Winning Bid Amount, Winning Bidder Name, Winning Bidder Telephone Number, Winning...

Hi, I have a spreadsheet that I need to calculate a weighted score for each entered criteria - See table below. Each bidder will be given a score out of 10 for each of the criteria. Each criterion will be given a 'weighting' which is a multiplier for the score. This will then give each bidder...

I am looking for a formula that would compare values in three non-contiguous cells (all in same row), and return the value (or values) in the Row 1 cell that corresponds with the minimum value(s) of those cells. In sample table below, looking for formula for cells G2 through G5. In sample...

Hi Guys, I've tried searching for a solution but couldn't come up with anything that was suitable. Basically, I want to try to find the min price of each item bid by each vendor. This I can do easily using excel formulas but the problem comes up when I want to find the min price of only...