Price Comparison Table
JFERRIER84
Posted messages
4
Status
Member
-
Raymond PENTIER Posted messages 58207 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58207 Registration date Status Contributor Last intervention -
Hello,
I'm creating this post because I need help from people skilled in EXCEL to create a comparative table:
I have a file with 6 pages containing 6 pricing grids: they give me a rate for each destination (department) from 1 to 95 + Monaco based on the number of pallets from 1 to 33.
I would like to create a summary table on the first page with a formula that can compare the 6 offers for each destination based on the quantity to display the name of the cheapest carrier.
I have attached an image of what I would like to achieve with an old table that was simpler as it only compared 2 offers.
Thank you for your assistance
I'm creating this post because I need help from people skilled in EXCEL to create a comparative table:
I have a file with 6 pages containing 6 pricing grids: they give me a rate for each destination (department) from 1 to 95 + Monaco based on the number of pallets from 1 to 33.
I would like to create a summary table on the first page with a formula that can compare the 6 offers for each destination based on the quantity to display the name of the cheapest carrier.
I have attached an image of what I would like to achieve with an old table that was simpler as it only compared 2 offers.
Thank you for your assistance
5 answers
Hello,
it is preferable to share an (anonymized) file rather than a screenshot.
For this: https://www.cjoint.com/
--
Remember to say "thank you" and mark as "resolved" when the issue is resolved.
it is preferable to share an (anonymized) file rather than a screenshot.
For this: https://www.cjoint.com/
--
Remember to say "thank you" and mark as "resolved" when the issue is resolved.
JFERRIER84
Posted messages
4
Status
Member
Thank you, I was actually trying to do that yesterday.
