matt-gilbert
Member
Hi all,
I have a quote comparison sheet which has a section in which to analyze supplier quotes minimum, average and maximum costs. The problem I have is that I need to manually adjust formula when using for another commodity type. I would like this formula to automatically adjust for different commodities. I have attached sample spreadsheet which further details what I'm after.
Any help would be very much appreciated. Thanks in advance. Matt
I have a quote comparison sheet which has a section in which to analyze supplier quotes minimum, average and maximum costs. The problem I have is that I need to manually adjust formula when using for another commodity type. I would like this formula to automatically adjust for different commodities. I have attached sample spreadsheet which further details what I'm after.
Any help would be very much appreciated. Thanks in advance. Matt