Hi, I have a sheet with prices of different products from different companies. I would like to find out which price is the lowest and write it to the next column with the name of the company who has the lowest price for that particular product (row). Additionally it would be great to have visual formatting of the lowest price in the original data.
Below you can find a sample document with original data and with "simulated result" below.
sample-worksheet.xlsx
Any help would be appreciated. Thanks!
Bookmarks