Hello there
I have a worksheet where I am summarising all the prices received by the suppliers. What I want to do is to go through the individuals worksheets and find the lowest price (=Min) and then bring that lowest price to a cell whcih I have done, but then I need to write a the column next to that lowest price the name of the supplier (or worksheet) where that price was located....
How can I do that?
Thanks for your help, much appreciated
I have a worksheet where I am summarising all the prices received by the suppliers. What I want to do is to go through the individuals worksheets and find the lowest price (=Min) and then bring that lowest price to a cell whcih I have done, but then I need to write a the column next to that lowest price the name of the supplier (or worksheet) where that price was located....
How can I do that?
Thanks for your help, much appreciated
