Hello
I have a question of how to selectively rank.
My table looks like this below.
example.jpg
I have to evaluate various quotations by numerous suppliers for several items. I need to be able to say, for example "for Item 1, supplier X has the 1st lowest price, followed by Supplier Y" in order to shortlist for negotiation.
I have 269 items to evaluate so doing this manually isnt the best option.
I've attached an example spreadsheet. Any help would be appreciated.
Cheers
R
Bookmarks