Need SKU of duplicate/same items sourcing from different Suppliers with best price

[raj2206]

Hello All,

I need help on getting SKU value of duplicate/same items sourcing from different Suppliers with best price in the column F.

Col # Title
Column A Supplier Name
Column B SKU
Column C Model #
Column D Count of Model#
Column E Price After Discount
Column F Best Price SKU (Need the SKU of best Priced Vendor)

below is the sample of my data -

Supplier Name SKU Model # Count of Model# Price After Discount Best Price SKU
MAUR MAUR_A A 3 2.04
BLAC BLAC_A A 3 2.88
GREN GREN_A A 3 2.88
NORP NORP_B B 1 2.232
DANR DANR_C C 4 2.0805
BANR BANR_C C 4 2.0805
LMAR LMAR_C C 4 2.87
CANR CANR_C C 4 2.79
GRAF GRAF_D D 4 8.13
DARI DARI_D D 4 7.245
ALVN ALVN_D D 4 7.245
MART MART_D D 4 9.04
VOTN VOTN_E E 4 1.37
MART MART_E E 4 1.278
NOTN NOTN_E E 4 1.37
DARI DARI_E E 4 1.278
UAQT UAQT_F F 4 2.03
RAQU RAQU_F F 4 2.03
GMAR GMAR_F F 4 2.51
LMAR LMAR_F F 4 2.59
DARI DARI_G G 4 1.089
VERI VERI_G G 4 1.089
POLY POLY_G G 4 1.099
ALVN ALVN_G G 4 1.34
GRAF GRAF_H H 4 6.16
FRAF FRAF_H H 4 6.17
DARI DARI_H H 4 5.481
MGRM MGRM_H H 4 8.21
GREN GREN_I I 4 2.19
BLAC BLAC_I I 4 2.19
MAUR MAUR_I I 4 2.32
NGAR NGAR_I I 4 1.73
FLAC FLAC_J J 2 6.82
GRAF GRAF_J J 2 6.83
GRAF GRAF_K K 3 2.71
CSTR CSTR_K K 3 3.02
MART MART_K K 3 3.02

Thanks,
Raj

 

[Peter_SSs]

I can't be clear on your layout from that post. Have you tried any of the suggestions in section B of the Forum Use Guidelines?

 

[raj2206]

My Apologies, I have pasted the data again with COMMA separated values, please let me know if this is acceptable.

Supplier Name,SKU,Model #,Count of Model#,Price After Discount,Best Price SKU
MAUR,MAUR_A,A,3,2.04
BLAC,BLAC_A,A,3,2.88
GREN,GREN_A,A,3,2.88
NORP,NORP_B,B,1,2.232
DANR,DANR_C,C,4,2.0805
BANR,BANR_C,C,4,2.0805
LMAR,LMAR_C,C,4,2.87
CANR,CANR_C,C,4,2.79
GRAF,GRAF_D,D,4,8.13
DARI,DARI_D,D,4,7.245
ALVN,ALVN_D,D,4,7.245
MART,MART_D,D,4,9.04
VOTN,VOTN_E,E,4,1.37
MART,MART_E,E,4,1.278
NOTN,NOTN_E,E,4,1.37
DARI,DARI_E,E,4,1.278
UAQT,UAQT_F,F,4,2.03
RAQU,RAQU_F,F,4,2.03
GMAR,GMAR_F,F,4,2.51
LMAR,LMAR_F,F,4,2.59
DARI,DARI_G,G,4,1.089
VERI,VERI_G,G,4,1.089
POLY,POLY_G,G,4,1.099
ALVN,ALVN_G,G,4,1.34
GRAF,GRAF_H,H,4,6.16
FRAF,FRAF_H,H,4,6.17
DARI,DARI_H,H,4,5.481
MGRM,MGRM_H,H,4,8.21
GREN,GREN_I,I,4,2.19
BLAC,BLAC_I,I,4,2.19
MAUR,MAUR_I,I,4,2.32
NGAR,NGAR_I,I,4,1.73
FLAC,FLAC_J,J,2,6.82
GRAF,GRAF_J,J,2,6.83
GRAF,GRAF_K,K,3,2.71
CSTR,CSTR_K,K,3,3.02
MART,MART_K,K,3,3.02

 

[Peter_SSs]

My Apologies, I have pasted the data again with COMMA separated values, please let me know if this is acceptable.

Well, it is better, but not as good as below.

Have you tried any of the suggestions in section B of the Forum Use Guidelines?

If this is the correct data layout, what are the expected results in column F, and why?

Excel Workbook
	A	B	C	D	E	F
1	Supplier Name	SKU	Model #	Count of Model#	Price After Discount	Best Price SKU
2	MAUR	MAUR_A	A	3	2.04
3	BLAC	BLAC_A	A	3	2.88
4	GREN	GREN_A	A	3	2.88
5	NORP	NORP_B	B	1	2.232
6	DANR	DANR_C	C	4	2.0805
7	BANR	BANR_C	C	4	2.0805
8	LMAR	LMAR_C	C	4	2.87
9	CANR	CANR_C	C	4	2.79
10	GRAF	GRAF_D	D	4	8.13
11	DARI	DARI_D	D	4	7.245
12	ALVN	ALVN_D	D	4	7.245
13	MART	MART_D	D	4	9.04
14	VOTN	VOTN_E	E	4	1.37
15	MART	MART_E	E	4	1.278
16	NOTN	NOTN_E	E	4	1.37
17	DARI	DARI_E	E	4	1.278
18	UAQT	UAQT_F	F	4	2.03
19	RAQU	RAQU_F	F	4	2.03
20	GMAR	GMAR_F	F	4	2.51
21	LMAR	LMAR_F	F	4	2.59
22	DARI	DARI_G	G	4	1.089
23	VERI	VERI_G	G	4	1.089
24	POLY	POLY_G	G	4	1.099
25	ALVN	ALVN_G	G	4	1.34
26	GRAF	GRAF_H	H	4	6.16
27	FRAF	FRAF_H	H	4	6.17
28	DARI	DARI_H	H	4	5.481
29	MGRM	MGRM_H	H	4	8.21
30	GREN	GREN_I	I	4	2.19
31	BLAC	BLAC_I	I	4	2.19
32	MAUR	MAUR_I	I	4	2.32
33	NGAR	NGAR_I	I	4	1.73
34	FLAC	FLAC_J	J	2	6.82
35	GRAF	GRAF_J	J	2	6.83
36	GRAF	GRAF_K	K	3	2.71
37	CSTR	CSTR_K	K	3	3.02
38	MART	MART_K	K	3	3.02
Best Price

 

[raj2206]

Dear Peter.

Thanks for the response, the data is correct, I will make sure to use the correct format next time when I post.

1. In column F I need the best price SKU of a Model #, for example Model #A is being bought from three SKUs MAUR_A, BLAC_A and GREN_A, since MAUR_A is the cheapest I need that value in column F.

2. Model # could have different duplicates as we can source the same product from one or multiple companies.

Thanks,
Raj