I've been told I'm not too great at describing, but here goes.
I have 2 columns to deal with. They represent bidding strings.
column A is the item number being bid on. If there are 15 bids on item 1, then there are 15 rows for item 1.
column B is the current bid for the item. If the bidding started at 1 and ended at 15, increasing by increments of 1 for each bid, then the sheet would look like this...
Item Bid
1 1
.... ...
1 15
What I wan to do is create a statement that will show what percent of the bids are within 85% of the final bid, then move on to the next item number and do the same. Thank you for your help!
I have 2 columns to deal with. They represent bidding strings.
column A is the item number being bid on. If there are 15 bids on item 1, then there are 15 rows for item 1.
column B is the current bid for the item. If the bidding started at 1 and ended at 15, increasing by increments of 1 for each bid, then the sheet would look like this...
Item Bid
1 1
.... ...
1 15
What I wan to do is create a statement that will show what percent of the bids are within 85% of the final bid, then move on to the next item number and do the same. Thank you for your help!
