Price comparison for Products

Question

Hi All,Hope you are doing well!...Can you please me with this problem below..I am providing the data and the expected output below: I have three columns Product ID,Company and Price ..B&amp;Co is my company..I am trying to compare the product price of my company to other companies and trying to get the difference between B&amp;Co price and the lowest price for this product....Also below the table output that I am expecting...I have attached the excel file too for the same..Note: Some of the company names are blank ...Also I have data for about 1000 products like this...Trying to build the output table as outlined below here:Can you please help!!Product ID Company Price&nbsp;5678&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&amp;co&nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Coke&nbsp; &nbsp; &nbsp; &nbsp;12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Red rhino&nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Discountland 3.58945&nbsp; &nbsp; B&amp;co&nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; Dataalchemy 7&nbsp; &nbsp; &nbsp; &nbsp;Unknown&nbsp; &nbsp; &nbsp; &nbsp;9&nbsp; &nbsp; &nbsp; &nbsp;Traveltools&nbsp; &nbsp; &nbsp;6.59022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; B&amp;co&nbsp; 40&nbsp; &nbsp; &nbsp; BeezBee 45&nbsp; &nbsp; &nbsp; Junipers&nbsp; 48Expected output :Product ID B&amp;co Price Lowest Price for Product&nbsp; Difference5678&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 18945&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3.59022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0

haytham amairah · Accepted Answer

Arun Chandramouli&nbsp;Please find the attached file to see my suggested solution.And you need to fill down product ID as the below screenshot to make the solution works.&nbsp;&nbsp;Hope that help

Forum Discussion

Price comparison for Products

1 Reply

Resources