Discussions Populaires Dans la Communauté Achats de comparaison

Excel: If we have 5 different suppliers of same products having prices as per their policies, we have to extract that which supplier is cheapest in which product or which product should we purchase from which supplier. Which formula we can use? ‎

As a consumer, would you buy a product from a brand you like even at standard prices or will you wait for a discount ?‎

which of the following experiences do you prefer to buy personal accessories like mobiles, clothes, fashion accessories etc - the comfort of using online purchase sites at convenience. or do you prefer the real-life feel of visiting the stores and buying? ‎

Problem in comparison. I am Unique orr not?‎

 

La répondre a été ajoutée par  Zeeshan Syed, Presales Business Consultant, HPE
Depuis 8 années

I will buy a brand of my choice on Standard Price if there is no discount available when I need the product the most.     

 

La répondre a été ajoutée par  Renat Gabidullin, Digital Marketing Specialist, DNS Digital Store
Depuis 8 années

If the column A - supplier, column B - product, column C - the price, in the D column you want to insert the formula ={IF(MIN(IF($B$2:$B$10=B2;$C$2:$C$10))=C2;1;0)}. A va ... Voir Plus

 

La répondre a été ajoutée par  Firas Shahadi, Human Resources Director, SAUDI UNION
Depuis 8 années

you need to use  min(): to find the minimum for selected supplier index(), match(): to allocate target cell or cells

 

La répondre a été ajoutée par  Utilisateur supprimé
Depuis 8 années

you should use both of the below formulas: V lookup/H lookup - to make a search field to determine the companies that you are looking for, then you have to use : =MIN for ... Voir Plus

 

La répondre a été ajoutée par  Mark Filor Paballa, Merchandiser/Sales Associate, DITRIO TRADING INC.
Depuis 8 années

i like going to store and see the actual image,texture,size,weight of the product