L
LooPrEvil
I want to use Excel to evaluate quotations as and when received. I would like to input the various stage payments offered into the spreadsheet and total them all up for each company - no problem with that bit.
I would like the software to then rank them in order of ascending price (so the cheapest price will rank '1', second cheapest ranked '2' etc.
I can use an 'IF' statement if there are only two bids ie: =IF(A10<B10,1,2) whill will rank the first price either 1 or 2, and then the cell references can be reversed to do the same for the second bid.
The difficulty I have is when a 3rd or 4th quotation is added. Does any body know how the formula should be written? I want to create a template to use on different jobs, so I can just input the rates / costs in future, and the system will automatically rank them.
Thanks.
I would like the software to then rank them in order of ascending price (so the cheapest price will rank '1', second cheapest ranked '2' etc.
I can use an 'IF' statement if there are only two bids ie: =IF(A10<B10,1,2) whill will rank the first price either 1 or 2, and then the cell references can be reversed to do the same for the second bid.
The difficulty I have is when a 3rd or 4th quotation is added. Does any body know how the formula should be written? I want to create a template to use on different jobs, so I can just input the rates / costs in future, and the system will automatically rank them.
Thanks.
