Home

Price comparison for Products

%3CLINGO-SUB%20id%3D%22lingo-sub-679526%22%20slang%3D%22en-US%22%3EPrice%20comparison%20for%20Products%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679526%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20All%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EHope%20you%20are%20doing%20well!...Can%20you%20please%20me%20with%20this%20problem%20below..I%20am%20providing%20the%20data%20and%20the%20expected%20output%20below%3A%20I%20have%20three%20columns%20Product%20ID%2CCompany%20and%20Price%20..B%26amp%3BCo%20is%20my%20company..I%20am%20trying%20to%20compare%20the%20product%20price%20of%20my%20company%20to%20other%20companies%20and%20trying%20to%20get%20the%20difference%20between%20B%26amp%3BCo%20price%20and%20the%20lowest%20price%20for%20this%20product....Also%20below%20the%20table%20output%20that%20I%20am%20expecting...I%20have%20attached%20the%20excel%20file%20too%20for%20the%20same..Note%3A%20Some%20of%20the%20company%20names%20are%20blank%20...Also%20I%20have%20data%20for%20about%201000%20products%20like%20this...Trying%20to%20build%20the%20output%20table%20as%20outlined%20below%20here%3ACan%20you%20please%20help!!%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EProduct%20ID%20Company%20Price%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E5678%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BB%26amp%3Bco%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B4%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BCoke%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B12%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BRed%20rhino%26nbsp%3B%203%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Discountland%203.5%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E8945%26nbsp%3B%20%26nbsp%3B%20B%26amp%3Bco%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B10%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Dataalchemy%207%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BUnknown%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B9%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BTraveltools%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B6.5%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E9022%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B50%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20B%26amp%3Bco%26nbsp%3B%2040%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20BeezBee%2045%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Junipers%26nbsp%3B%2048%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EExpected%20output%20%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EProduct%20ID%20B%26amp%3Bco%20Price%20Lowest%20Price%20for%20Product%26nbsp%3B%20Difference%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E5678%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%204%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B3%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%201%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E8945%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B10%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%206.5%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%203.5%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E9022%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B40%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B40%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%200%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-679526%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-679554%22%20slang%3D%22en-US%22%3ERe%3A%20Price%20comparison%20for%20Products%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679554%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F216929%22%20target%3D%22_blank%22%3E%40Arun%20Chandramouli%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20find%20the%20attached%20file%20to%20see%20my%20suggested%20solution.%3C%2FP%3E%3CP%3EAnd%20you%20need%20to%20fill%20down%20product%20ID%20as%20the%20below%20screenshot%20to%20make%20the%20solution%20works.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117549iBAFB92BC50FFFB70%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-06-09_19-10-28.png%22%20title%3D%222019-06-09_19-10-28.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
Arun Chandramouli
New Contributor

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&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&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 

5678             B&co       4
                     Coke       12
                   Red rhino  3
                Discountland 3.5

8945    B&co     10
        Dataalchemy 7
       Unknown       9
       Traveltools     6.5

9022           50
        B&co  40
      BeezBee 45
      Junipers  48


Expected output :

Product ID B&co Price Lowest Price for Product  Difference
5678              4                         3                              1
8945             10                      6.5                            3.5
9022             40                       40                              0

1 Reply

@Arun Chandramouli

 

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.

2019-06-09_19-10-28.png

 

 

Hope that help

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies