AyeshaAzmi
New Member
- Joined
- Apr 6, 2013
- Messages
- 1
I have an excel sheet with PRICES of various THICKNESSES of Boards from different SUPPLIERS with further SPECS (Glue used, Payment terms, etc.).
I need a simple and fast way to SUMMARIZE the data to only show me the LOWEST PRICE of EACH THICKNESS with the Suppliers name and all the specs.
I have tried playing with Pivot Tables but never works and I end up getting the MIN Price of Each Thickness and then MANUALLY have to insert the corresponding data, which is extremely inconvenient as the prices go up and down regularly, so I have to change the the whole table every time.
This is how the FULL DATA SHEET looks
This is how I want it to be SUMMARIZED Automatically (this was done through Pivot table [Thickness = Row Label | Min of USD/Pcs = Value] and then the rest of information was MANUALLY Inserted)
I would really appreciate a solution as I AM SURE EXCEL HAS IT but I am just a hard time figuring it out.
Thanks,
Ayesha
I need a simple and fast way to SUMMARIZE the data to only show me the LOWEST PRICE of EACH THICKNESS with the Suppliers name and all the specs.
I have tried playing with Pivot Tables but never works and I end up getting the MIN Price of Each Thickness and then MANUALLY have to insert the corresponding data, which is extremely inconvenient as the prices go up and down regularly, so I have to change the the whole table every time.
This is how the FULL DATA SHEET looks
This is how I want it to be SUMMARIZED Automatically (this was done through Pivot table [Thickness = Row Label | Min of USD/Pcs = Value] and then the rest of information was MANUALLY Inserted)
I would really appreciate a solution as I AM SURE EXCEL HAS IT but I am just a hard time figuring it out.
Thanks,
Ayesha
Last edited:
