Trending Comparison Shopping Discussions

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

Answers:

3

Followers:

3

Views:

1641

Vote Count:

0

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

Answers:

1

Followers:

1

Views:

168

Vote Count:

0

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

Answers:

1

Followers:

1

Views:

201

Vote Count:

0

Problem in comparison. I am Unique orr not?‎

Answers:

0

Followers:

0

Views:

0

Vote Count:

0

 

Answer added by  Zeeshan Syed, Presales Business Consultant, HPE
8 years ago

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

 

Answer added by  Renat Gabidullin, Digital Marketing Specialist, DNS Digital Store
7 years ago

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 ... See More

 

Answer added by  Firas Shahadi , Training And Development Director, Muhayal Assir National Hospital
7 years ago

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

 

Answer added by  Deleted user
7 years ago

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 ... See More

 

Answer added by  Mark Filor Paballa, Merchandiser/Sales Associate, DITRIO TRADING INC.
8 years ago

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