Ayesha Azmi
New member
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.
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.
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