Excel logic for multiple conditions

[Manatarms]

Hi - some help needed please as it’s making my brain explode…!

I have rows of data of parts that are ordered by different shops. I need to identify when the same shop has made orders for 2 specific parts on a list - they can order other parts - but only if they make orders for both parts as this makes a set.
Each row has only 1 part per row so needs to be able to identify firstly if there are orders for the 2 parts from the list in the dataset, then work out if they are from the same shop.


Hopefully this makes sense, any help greatly appreciated! Thks

 

[JamesCanale]

I'm not sure if I got what you want... This will look for a match for the same shop on the same day for the related part.

MrExcelPlayground4.xlsx
	A	B	C	D	E	F
1	Date	Shop	Part	Problem?		Parts that should be a pair
2	10/1/2021	A	100			200
3	10/1/2021	A	300			201
4	10/1/2021	A	200	Problem
5	10/1/2021	B	100
6	10/1/2021	B	101
7	10/1/2021	C	200
8	10/1/2021	C	201
9	10/1/2021	C	300
10	10/1/2021	C	301
11	10/1/2021	C	400
12	10/2/2021	A	200
13	10/2/2021	A	201
14	10/2/2021	A	300
15	10/2/2021	B	100
16	10/2/2021	B	101
17	10/3/2021	A	102
18	10/3/2021	A	103
19	10/3/2021	B	200
20	10/3/2021	B	201
21	10/3/2021	C	100
22	10/3/2021	C	102
23	10/3/2021	C	103
24	10/3/2021	C	200	Problem
25	10/3/2021	C	250
26	10/3/2021	C	300
27	10/3/2021	C	350
28	10/3/2021	C	400
29	10/4/2021	A	115
30	10/4/2021	A	201	Problem
31	10/4/2021	A	250
32	10/4/2021	A	340
33	10/4/2021	A	500
34	10/4/2021	B	200
35	10/4/2021	B	201
36	10/4/2021	B	250
37	10/4/2021	B	300
38	10/4/2021	C	100
39	10/4/2021	C	101
Sheet16

Cell Formulas
Range	Formula
D2:D39	D2	=IF(ISNA(IF(C2=F$2,MATCH(A2&B2&$F$3,$A$2:$A$39&$B$2:$B$39&$C$2:$C$39,0),IF(C2=F$3,MATCH(A2&B2&$F$2,$A$2:$A$39&$B$2:$B$39&$C$2:$C$39,0),""))),"Problem","")

 

[Manatarms]

Many thanks James, however it’s not quite what I need - my bad for not explaining properly sorry.
I need to know how many sets of parts each shop is buying, so using your data as an example, shop A has bought two sets (200 and 201 x 2 each). Shop C has bought one set (200 and 201) so I need the total number of sets bought. Shop C has also bought another 200 (10/3/21) but as there is not a second purchase for another 201 this is not a full set.
Hopefully that is a bit clearer! Thanks again!

 

[JamesCanale]

Maybe it's simpler then...

MrExcelPlayground4.xlsx
	A	B	C	D	E	F	G	H
1	Date	Shop	Part	Problem?		Parts that should be a pair
2	10/1/2021	A	100			200
3	10/1/2021	A	300			201
4	10/1/2021	A	200	Problem
5	10/1/2021	B	100
6	10/1/2021	B	101
7	10/1/2021	C	200
8	10/1/2021	C	201
9	10/1/2021	C	300			Shop	200	201
10	10/1/2021	C	301			A	2	2
11	10/1/2021	C	400			B	2	2
12	10/2/2021	A	200			C	2	1
13	10/2/2021	A	201
14	10/2/2021	A	300
15	10/2/2021	B	100
16	10/2/2021	B	101
17	10/3/2021	A	102
18	10/3/2021	A	103
19	10/3/2021	B	200
20	10/3/2021	B	201
21	10/3/2021	C	100
22	10/3/2021	C	102
23	10/3/2021	C	103
24	10/3/2021	C	200	Problem
25	10/3/2021	C	250
26	10/3/2021	C	300
27	10/3/2021	C	350
28	10/3/2021	C	400
29	10/4/2021	A	115
30	10/4/2021	A	201	Problem
31	10/4/2021	A	250
32	10/4/2021	A	340
33	10/4/2021	A	500
34	10/4/2021	B	200
35	10/4/2021	B	201
36	10/4/2021	B	250
37	10/4/2021	B	300
38	10/4/2021	C	100
39	10/4/2021	C	101
Sheet16

Cell Formulas
Range	Formula
G10:H12	G10	=COUNTIFS($B$2:$B$39,$F10,$C$2:$C$39,G$9)
D2:D39	D2	=IF(ISNA(IF(C2=F$2,MATCH(A2&B2&$F$3,$A$2:$A$39&$B$2:$B$39&$C$2:$C$39,0),IF(C2=F$3,MATCH(A2&B2&$F$2,$A$2:$A$39&$B$2:$B$39&$C$2:$C$39,0),""))),"Problem","")

 

[Manatarms]

This works a great! Many thanks for your help JamesCanale really appreciated!