View original (French)

Price Comparison Table

JFERRIER84 Posted messages 4 Status Member -  
Raymond PENTIER Posted messages 58209 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

5 answers

Answer 1 / 5
Yoyo01000 Posted messages 1720 Registration date   Status Member Last intervention   168
 
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.
0
JFERRIER84 Posted messages 4 Status Member
 
Thank you, I was actually trying to do that yesterday.
0