Discussions Populaires Dans la Communauté Achats de comparaison

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

Déprécier

Signaler CV

Modélisation des prix

Prix

Excel

Établissement des coûts

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? ‎

La répondre a été ajoutée par Firas Shahadi , Training And Development Director, Muhayal Assir National Hospital
Depuis 7 années

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

Déprécier

Signaler CV

Modélisation des prix

Prix

Excel

Établissement des coûts

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? ‎

La répondre a été ajoutée par Utilisateur supprimé
Depuis 7 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

Déprécier

Signaler CV

Vente en gros

Vente en ligne

Marques grand public

Achats de comparaison

Client Relationship Management CRM

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? ‎

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

Déprécier

Signaler CV

Irrelevant to Specialities or not an answer.

Inappropriate or offensive.

Spam (unsolicited advertising).

Produits Par Bayt.com

Utilisez l'Appli de Bayt.com

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?‎

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

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? ‎

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? ‎

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? ‎

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? ‎