Thread
:
Help With A Spreadsheet for a silent auction
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Steve Dunn
external usenet poster
Posts: 193
Help With A Spreadsheet for a silent auction
Ken,
take a look at SUMIF for the total spend. You may need an array formula to
collect the item numbers, but you don't really give enough clear information
to work with here (imho).
"Ken P" <Ken
wrote in message
...
I am trying to create a spreadsheet to help with a silent auction. What I
would like to do is enter the winners bidder number as well as the winning
bid in 2 columns corresponding to the item number. I originally thought of
creating an individual work sheet for each item, then just entering the
bidder number and winning bid in to each sheet and having the formula
search
through all the sheets.
Either way, I need to then search through the information I have put in so
that I can easily gather the total amount a bidder has spent, as well as
the
item numbers that they have won. If anyone can help, it would be greatly
appreciated. If it would be easier to do it all on one sheet, or making
separate sheets, whatever you can help with would be great. Thank you in
advance.
Reply With Quote
Steve Dunn
View Public Profile
Find all posts by Steve Dunn