How to state yes to lowest price by seller for specific item?

[Kirstie99]

Any help is appreciated! I am trying to select unique items per seller, but want it to say "Yes" on the lowest price. In my file I have Item_Seller and I just used =+IF(MATCH(A2,A:A,0)=ROW(),"yes","No") but I dont know how to have it look at price too and select the lowest? TIA!!!

Item_Seller	Item #	Seller	Price	Unique item per Seller, lowest price
1234_Bob	1234	Bob	5.99	Yes
1234_Bob	1234	Bob	4.99
1234_Steve	1234	Steve	5.79	Yes
1234_Henry	1234	Henry	3.21	Yes

 

[coulombevin]

Hi Kirstie99,

If your excel version is 365, here's what I would do: *I am using the French version of Excel 365, so there might be some errors due to manual translation or discrepancies in the Excel user manual*

=IF($D2=MIN(FILTER($D:$D,($B:$B=$B2)*($C:$C=$C2),"")),"Yes","No")

Bests regards,

Vincent

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Kirstie99]

Hi Kirstie99,

If your excel version is 365, here's what I would do: *I am using the French version of Excel 365, so there might be some errors due to manual translation or discrepancies in the Excel user manual*

=IF($D2=MIN(FILTER($D:$D,($B:$B=$B2)*($C:$C=$C2),"")),"Yes","No")

Bests regards,

Vincent

Thank you so much!!!!

 

[Kirstie99]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Thank you for the tip! 365, I just updated

 

[coulombevin]

Thank you so much!!!!

Hi Kristie,

No problem. If it work, could you write it as Solution?

Thanks,

Vincent

 

[Cubist]

Another option:

Book6
	A	B	C	D	E
1	Item_Seller	Item #	Seller	Price	Unique item per Seller, lowest price
2	1234_Bob	1234	Bob	5.99	No
3	1234_Bob	1234	Bob	4.99	Yes
4	1234_Steve	1234	Steve	5.79	Yes
5	1234_Henry	1234	Henry	3.21	Yes
Sheet1

Cell Formulas
Range	Formula
E2:E5	E2	=IF(D2=MINIFS(D:D,B:B,B2,C:C,C2),"Yes","No")