Supplier Pricing Comparison Table
Manu
-
Raymond PENTIER Posted messages 58207 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58207 Registration date Status Contributor Last intervention -
Hello,
Configuration: Windows 7 / Mozilla 11.0
I work in a small business, and I need to set up a table to compare suppliers' prices for all kinds of items, whether it's fuel, gloves, safety shoes, cups, etc.
I don't know how to get started.
Any ideas, please?
Thanks in advance.
Configuration: Windows 7 / Mozilla 11.0
I work in a small business, and I need to set up a table to compare suppliers' prices for all kinds of items, whether it's fuel, gloves, safety shoes, cups, etc.
I don't know how to get started.
Any ideas, please?
Thanks in advance.
2 answers
Hello,
A first suggestion:
1) In the first columns, identify the item (e.g. Column A="Buyer Service"; Column B="Product Type"; Column C="Item"
2) Then, keep one column that will calculate the average price using a formula based on the following columns
3) Finally, take one column per supplier to indicate their price for the item in question
To maintain a practical and dynamic view of the created database, I recommend using a pivot table in another sheet of the Excel document ;)
Best regards,
A first suggestion:
1) In the first columns, identify the item (e.g. Column A="Buyer Service"; Column B="Product Type"; Column C="Item"
2) Then, keep one column that will calculate the average price using a formula based on the following columns
3) Finally, take one column per supplier to indicate their price for the item in question
To maintain a practical and dynamic view of the created database, I recommend using a pivot table in another sheet of the Excel document ;)
Best regards,
