I am trying to set up a spreadsheet where I can host an auction where I can display the bidder's names, bidder's assigned number, items, items bidded, winning $, and winner's bid number. I am having a hard time creating formulas where I can locate the highest bid amount for a specific item and display who the winner is.
Here's an example of the spreadsheet I need help with:
Bid # * Name * 1st Item * Bid Price * 2nd Item * Bid Price
1 * Amy * A * $1 * C * $10
2 * Ben * B * $2 * B * $20
3 * Cindy * C * $3 * A * $30
4 David D $4 B $40
5 Ed E $5 A $50
6 Frances A $6 E $60
7 Grace G $7 D $70
8 Hilary B $8 H $80
9 Irene I $9 G $90
10 Jack J $10 C $100
(Please note that there is * on the header and the first three rows to to help seperate the text so it would be easier to read, it DOES NOT mean to multiply.)
Here's what I need excel to help me with:
Find the highest $ bidded for Item A, B, C, etc.
Find the person who won each item
After finding the person who won what which items with the Bid Amt, associate their bid # with them.
Please note that each person may bid more than one item so Amy can bid for all three items A, B, C,etc. if she like. I need to calculate her bidding total amount, whether she won anything and what the amount was.
It would be really helpful if I am able to set up a spreadsheet that is user-friendly enough as well.
I have been trying to find the highest bidding amount with respective of each item but I have not been very lucky. Finding the winner would be awesome too because this is an auction so it would be pretty important to locate a winner...
Please help!
Thank you!
Here's an example of the spreadsheet I need help with:
Bid # * Name * 1st Item * Bid Price * 2nd Item * Bid Price
1 * Amy * A * $1 * C * $10
2 * Ben * B * $2 * B * $20
3 * Cindy * C * $3 * A * $30
4 David D $4 B $40
5 Ed E $5 A $50
6 Frances A $6 E $60
7 Grace G $7 D $70
8 Hilary B $8 H $80
9 Irene I $9 G $90
10 Jack J $10 C $100
(Please note that there is * on the header and the first three rows to to help seperate the text so it would be easier to read, it DOES NOT mean to multiply.)
Here's what I need excel to help me with:
Find the highest $ bidded for Item A, B, C, etc.
Find the person who won each item
After finding the person who won what which items with the Bid Amt, associate their bid # with them.
Please note that each person may bid more than one item so Amy can bid for all three items A, B, C,etc. if she like. I need to calculate her bidding total amount, whether she won anything and what the amount was.
It would be really helpful if I am able to set up a spreadsheet that is user-friendly enough as well.
I have been trying to find the highest bidding amount with respective of each item but I have not been very lucky. Finding the winner would be awesome too because this is an auction so it would be pretty important to locate a winner...
Please help!
Thank you!