How to filter function and SUM based on Partial Text Match (SUMIFS with wildcards)

[Lacan]

Dear Guys,

Not using VBA Code, accordingly with criteria (Customer Name+Month) how to filter function and SUM based on Partial Text Match (SUMIFS with wildcards)?
Hope someone could help???
Thank you very much!!!

Search by Name_2.xlsm
	B	C	D	E	F	G	H	I	J	K
2	CRITERIA						DATA BASE
3	Customer Name	Month	Product Name Abbreviation		EXCLUSIVES CUSTOMERS	EXCLUSIVES MONTH	Customer Name	Month	Product Name	Units
4	CNY	feb. 2023	Rosuva+Ezet		ABA	jan. 2023	ABA	feb. 2023	ESPIRONOLACTONA 100 MG - 60 COMP.	1
5			Amlod+Olmes+Hctz		CNY	feb. 2023	ABA	feb. 2023	SINVASTATINA 20 MG - 60 COMP.	80
6			Metform+Vilda		DIL		ABA	feb. 2023	AMLODIPINA 10 mg - 60 Com	20
7							ABA	jan. 2023	PRAVASTATINA 20 MG - 60 COMP.	2
8							ABA	feb. 2023	NIFEDIPINA 20 MG - 60 COMP.	5
9							ABA	feb. 2023	SINVASTATINA 40 MG - 60 COMP.	2
10							ABA	feb. 2023	ROSUVASTATINA + EZETIMIBA 20 + 10 mg 60	4
11							ABA	jan. 2023	SERTRALINA 50 MG - 60 COMP.	24
12							ABA	jan. 2023	SERTRALINA 100 MG - 60 COMP.	20
13							ABA	feb. 2023	ROSUVASTATINA + EZETIMIBA 20 + 10 mg 60	16
14							CNY	feb. 2023	RAMIPRIL 2,5 MG - 56 CAPS.	2
15	RESULTS OF CRITERIA TABLE ABOVE						CNY	feb. 2023	RAMIPRIL 5 MG - 56 CAPS.	6
16	Product Name	Sum Units					CNY	feb. 2023	RAMIPRIL 10 MG - 56 CAPS.	6
17							CNY	feb. 2023	RAMIPRIL + HCTZ 5 MG/25 MG - 56 COMP.	1
18							CNY	feb. 2023	OLANZAPINA 2,5X28 MG	4
19							CNY	jan. 2023	PANTOPRAZOL 20 MG - 56 COMP.GASTRO-RESIST.	2
20							CNY	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	69
21							CNY	jan. 2023	MONTELUCASTE 10MG 28COMP	2
22							CNY	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	1
23							CNY	feb. 2023	PANTOPRAZOL 40 MG - 56 COMP.GASTRO-RESIST	2
24							CNY	jan. 2023	EBASTINA 10MG-20 COMP	6
25							DIL	feb. 2023	QUETIAPINA 25MG 20 COMP	12
26							DIL	feb. 2023	MONTELUCASTE 10MG 28COMP	2
27							DIL	feb. 2023	ESPIRONOLACTONA 25 MG - 60 COMP.	20
28							DIL	feb. 2023	METFORMINA + VILDAGLIPTINA 1000 + 50 mg 60	4
29							DIL	jan. 2023	CLOPIDOGREL GENERICOS 75MG 28C	50
30							DIL	feb. 2023	IRBESARTAN+HCTZ 150 12,5 28MG	4
31							DIL	jan. 2023	IRBESARTAN+HCTZ 300 12,5 28MG	2
32							DIL	feb. 2023	METFORMINA + VILDAGLIPTINA 1000 + 50 mg 60	3
Sheet1

Cell Formulas
Range	Formula
F4:F6	F4	=SORT(UNIQUE(H4:H32))
G4:G5	G4	=SORT(UNIQUE(I4:I32),,-1)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B5	List	=$G$4:$G$12
B4	List	=$F$4:$F$6
C4	List	=$G$4:$G$5

 

[Skyybot]

Does this example help?

Use SORT and FILTER together to sort a range in ascending order, and limit it to values over 5,000.

SORT function - Microsoft Support

Learn about the SORT function, which sorts the contents of a range or array. SORT is in a class of functions called dynamic arrays.

support.microsoft.com

 

[AhoyNC]

I think the VBA code that @DanteAmor gave you is the way to go if it worked.
The following seems to work if you can change the way you enter the Product Name Abb. and can add a helper column.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1
2		CRITERIA						DATA BASE
3		Customer Name	Month	Product Name Abbreviation		EXCLUSIVES CUSTOMERS	EXCLUSIVES MONTH	Customer Name	Month	Product Name	Units	Helper
4		ABA	feb. 2023	ROSUVASTATINA + EZETIMIBA		ABA	jan. 2023	ABA	feb. 2023	ESPIRONOLACTONA 100 MG - 60 COMP.	1	0
5				AMLOD+OLME+HCTZ		CNY	feb. 2023	ABA	feb. 2023	SINVASTATINA 20 MG - 60 COMP.	80	0
6				METFORMINA + VILDAGLIPTINA		DIL		ABA	feb. 2023	AMLODIPINA 10 mg - 60 Com	20	0
7				SERTRALINA				ABA	jan. 2023	PRAVASTATINA 20 MG - 60 COMP.	2	0
8								ABA	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	5	AMLOD+OLME+HCTZ
9								ABA	feb. 2023	SINVASTATINA 40 MG - 60 COMP.	2	0
10								ABA	feb. 2023	ROSUVASTATINA + EZETIMIBA 20 + 10 mg 60	4	ROSUVASTATINA + EZETIMIBA
11								ABA	feb. 2023	SERTRALINA 50 MG - 60 COMP.	24	SERTRALINA
12								ABA	feb. 2023	SERTRALINA 100 MG - 60 COMP.	20	SERTRALINA
13								ABA	feb. 2023	ROSUVASTATINA + EZETIMIBA 20 + 10 mg 60	16	ROSUVASTATINA + EZETIMIBA
14								CNY	feb. 2023	RAMIPRIL 2,5 MG - 56 CAPS.	2	0
15		RESULTS OF CRITERIA TABLE ABOVE						CNY	feb. 2023	RAMIPRIL 5 MG - 56 CAPS.	6	0
16		Product Name	Sum Units					CNY	feb. 2023	RAMIPRIL 10 MG - 56 CAPS.	6	0
17		AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	5					CNY	feb. 2023	RAMIPRIL + HCTZ 5 MG/25 MG - 56 COMP.	1	0
18		ROSUVASTATINA + EZETIMIBA 20 + 10 mg 60	20					CNY	feb. 2023	OLANZAPINA 2,5X28 MG	4	0
19		SERTRALINA 50 MG - 60 COMP.	24					CNY	jan. 2023	PANTOPRAZOL 20 MG - 56 COMP.GASTRO-RESIST.	2	0
20		SERTRALINA 100 MG - 60 COMP.	20					CNY	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	69	0
21								CNY	jan. 2023	MONTELUCASTE 10MG 28COMP	2	0
22								CNY	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	1	0
23								CNY	feb. 2023	PANTOPRAZOL 40 MG - 56 COMP.GASTRO-RESIST	2	0
24								CNY	jan. 2023	EBASTINA 10MG-20 COMP	6	0
25								DIL	feb. 2023	QUETIAPINA 25MG 20 COMP	12	0
26								DIL	feb. 2023	MONTELUCASTE 10MG 28COMP	2	0
27								DIL	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	20	0
28								DIL	feb. 2023	METFORMINA + VILDAGLIPTINA 1000 + 50 mg 60	4	0
29								DIL	jan. 2023	CLOPIDOGREL GENERICOS 75MG 28C	50	0
30								DIL	feb. 2023	IRBESARTAN+HCTZ 150 12,5 28MG	4	0
31								DIL	jan. 2023	IRBESARTAN+HCTZ 300 12,5 28MG	2	0
32								DIL	feb. 2023	METFORMINA + VILDAGLIPTINA 1000 + 50 mg 60	3	0
Sheet2

Cell Formulas
Range	Formula
F4:F6	F4	=SORT(UNIQUE(H4:H32))
G4:G5	G4	=SORT(UNIQUE(I4:I32),,-1)
B17:B20	B17	=UNIQUE(FILTER($J$4:$J$32,($I$4:$I$32=$C$4)*($H$4:$H$32=$B$4)*($L$4:$L$32<>0),""))
C17:C20	C17	=IF(B17#="","",SUMIFS($K$4:$K$32,$J$4:$J$32,B17#,$H$4:$H$32,$B$4))
C21	C21	=IF(B21="","",SUMIFS($K$4:$K$32,$J$4:$J$32,B21,$H$4:$H$32,$B$4))
L4:L32	L4	=IF(H4=$B$4,INDEX($D$4:$D$8,MATCH(1,COUNTIF(J4,"*"&$D$4:$D$8&"*"),0)),0)
Dynamic array formulas.

 

[Peter_SSs]

It is not clear to me exactly what you want. Can you manually fill in the expected results, post XL2BB again and explain in more detail in relation to those expected results?

 

[Lacan]

It is not clear to me exactly what you want. Can you manually fill in the expected results, post XL2BB again and explain in more detail in relation to those expected results?

Dear @Peter_SSs
Hope you are fine my friend.
Always a pleasure to see that you are still here helping.
As you asked here with expected results accordingly criteria.
Any more information please fell free to ask.
Thank you very much.
Big hug.

Search by Name_2.xlsm
	B	C	D	E	F	G	H	I	J	K
2	CRITERIA						DATA BASE
3	Customer Name	Month	Product Name Abbreviation		EXCLUSIVES CUSTOMERS	EXCLUSIVES MONTH	Customer Name	Month	Product Name	Units
4	CNY	feb. 2023	Rosuva+Ezet		ABA	jan. 2023	ABA	feb. 2023	ESPIRONOLACTONA 100 MG - 60 COMP.	1
5			Amlod+Olmes+Hctz		CNY	feb. 2023	ABA	feb. 2023	SINVASTATINA 20 MG - 60 COMP.	80
6			Metform+Vilda		DIL		ABA	feb. 2023	AMLODIPINA 10 mg - 60 Com	20
7							ABA	jan. 2023	PRAVASTATINA 20 MG - 60 COMP.	2
8							ABA	feb. 2023	NIFEDIPINA 20 MG - 60 COMP.	5
9							ABA	feb. 2023	SINVASTATINA 40 MG - 60 COMP.	2
10							ABA	feb. 2023	ROSUVASTATINA + EZETIMIBA 20 + 10 mg 60	4
11							ABA	jan. 2023	SERTRALINA 50 MG - 60 COMP.	24
12							ABA	jan. 2023	SERTRALINA 100 MG - 60 COMP.	20
13							ABA	feb. 2023	ROSUVASTATINA + EZETIMIBA 20 + 10 mg 60	16
14							CNY	feb. 2023	RAMIPRIL 2,5 MG - 56 CAPS.	2
15	RESULTS OF CRITERIA TABLE ABOVE						CNY	feb. 2023	RAMIPRIL 5 MG - 56 CAPS.	6
16	Product Name	Sum Units					CNY	feb. 2023	RAMIPRIL 10 MG - 56 CAPS.	6
17	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	70					CNY	feb. 2023	RAMIPRIL + HCTZ 5 MG/25 MG - 56 COMP.	1
18							CNY	feb. 2023	OLANZAPINA 2,5X28 MG	4
19							CNY	jan. 2023	PANTOPRAZOL 20 MG - 56 COMP.GASTRO-RESIST.	2
20							CNY	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	69
21							CNY	jan. 2023	MONTELUCASTE 10MG 28COMP	2
22							CNY	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	1
23							CNY	feb. 2023	PANTOPRAZOL 40 MG - 56 COMP.GASTRO-RESIST	2
24							CNY	jan. 2023	EBASTINA 10MG-20 COMP	6
25							DIL	feb. 2023	QUETIAPINA 25MG 20 COMP	12
26							DIL	feb. 2023	MONTELUCASTE 10MG 28COMP	2
27							DIL	feb. 2023	ESPIRONOLACTONA 25 MG - 60 COMP.	20
28							DIL	feb. 2023	METFORMINA + VILDAGLIPTINA 1000 + 50 mg 60	4
29							DIL	jan. 2023	CLOPIDOGREL GENERICOS 75MG 28C	50
30							DIL	feb. 2023	IRBESARTAN+HCTZ 150 12,5 28MG	4
31							DIL	jan. 2023	IRBESARTAN+HCTZ 300 12,5 28MG	2
32							DIL	feb. 2023	METFORMINA + VILDAGLIPTINA 1000 + 50 mg 60	3
Sheet1

Cell Formulas
Range	Formula
F4:F6	F4	=SORT(UNIQUE(H4:H32))
G4:G5	G4	=SORT(UNIQUE(I4:I32),,-1)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B5	List	=$G$4:$G$12
B4	List	=$F$4:$F$6
C4	List	=$G$4:$G$5

 

[Peter_SSs]

Did @AhoyNC's suggestion work for you?

I can't see how you got that expected result from your sample data so perhaps I am not understanding correctly. I thought that for a row to be included, at least one of the texts from column D needed to be found in column J. None of the texts in D4:D6 in your sample are found in those two green cells. Or is cell D5 a typo and it should be Amlod+Olme+Hctz not Amlod+Olmes+Hctz
I have assumed that was a typo and my suggestion also involves a helper column so is not too unlike @AhoyNC's suggestion.

Lacan.xlsm
	B	C	D	E	F	G	H	I	J	K	L
2	CRITERIA						DATA BASE
3	Customer Name	Month	Product Name Abbreviation		EXCLUSIVES CUSTOMERS	EXCLUSIVES MONTH	Customer Name	Month	Product Name	Units
4	CNY	feb. 2023	Rosuva+Ezet		ABA	jan. 2023	ABA	feb. 2023	ESPIRONOLACTONA 100 MG - 60 COMP.	1
5			Amlod+Olme+Hctz		CNY	feb. 2023	ABA	feb. 2023	SINVASTATINA 20 MG - 60 COMP.	80
6			Metform+Vilda		DIL		ABA	feb. 2023	AMLODIPINA 10 mg - 60 Com	20
7							ABA	jan. 2023	PRAVASTATINA 20 MG - 60 COMP.	2
8							ABA	feb. 2023	NIFEDIPINA 20 MG - 60 COMP.	5
9							ABA	feb. 2023	SINVASTATINA 40 MG - 60 COMP.	2
10							ABA	feb. 2023	ROSUVASTATINA + EZETIMIBA 20 + 10 mg 60	4
11							ABA	jan. 2023	SERTRALINA 50 MG - 60 COMP.	24
12							ABA	jan. 2023	SERTRALINA 100 MG - 60 COMP.	20
13							ABA	feb. 2023	ROSUVASTATINA + EZETIMIBA 20 + 10 mg 60	16
14							CNY	feb. 2023	RAMIPRIL 2,5 MG - 56 CAPS.	2
15	RESULTS OF CRITERIA TABLE ABOVE						CNY	feb. 2023	RAMIPRIL 5 MG - 56 CAPS.	6
16	Product Name	Sum Units					CNY	feb. 2023	RAMIPRIL 10 MG - 56 CAPS.	6
17	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	70					CNY	feb. 2023	RAMIPRIL + HCTZ 5 MG/25 MG - 56 COMP.	1
18							CNY	feb. 2023	OLANZAPINA 2,5X28 MG	4
19							CNY	jan. 2023	PANTOPRAZOL 20 MG - 56 COMP.GASTRO-RESIST.	2
20							CNY	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	69	70
21							CNY	jan. 2023	MONTELUCASTE 10MG 28COMP	2
22							CNY	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	1	70
23							CNY	feb. 2023	PANTOPRAZOL 40 MG - 56 COMP.GASTRO-RESIST	2
24							CNY	jan. 2023	EBASTINA 10MG-20 COMP	6
25							DIL	feb. 2023	QUETIAPINA 25MG 20 COMP	12
26							DIL	feb. 2023	MONTELUCASTE 10MG 28COMP	2
27							DIL	feb. 2023	ESPIRONOLACTONA 25 MG - 60 COMP.	20
28							DIL	feb. 2023	METFORMINA + VILDAGLIPTINA 1000 + 50 mg 60	4
29							DIL	jan. 2023	CLOPIDOGREL GENERICOS 75MG 28C	50
30							DIL	feb. 2023	IRBESARTAN+HCTZ 150 12,5 28MG	4
31							DIL	jan. 2023	IRBESARTAN+HCTZ 300 12,5 28MG	2
32							DIL	feb. 2023	METFORMINA + VILDAGLIPTINA 1000 + 50 mg 60	3
Sheet1

Cell Formulas
Range	Formula
F4:F6	F4	=SORT(UNIQUE(H4:H32))
G4:G5	G4	=SORT(UNIQUE(I4:I32),,-1)
B17:C17	B17	=UNIQUE(CHOOSECOLS(FILTER(J4:L100,L4:L100<>"",{"","",""}),1,3))
L4:L32	L4	=IF(AND(H4=B$4,I4=C$4,COUNT(SEARCH(FILTER(D$4:D$12,D$4:D$12<>""),J4))),SUMIFS(K$4:K$100,H$4:H$100,H4,I$4:I$100,I4,J$4:J$100,J4),"")
Dynamic array formulas.

 

[Lacan]

Dear @Peter_SSs

You are correct it is Amlod+Olme+Hctz not Amlod+Olmes+Hctz.
Just made that correction in all sheet.
Should it help to clarify the goal?
Thanks again pal.

Search by Name_2.xlsm
	B	C	D	E	F	G	H	I	J	K
2	CRITERIA						DATA BASE
3	Customer Name	Month	Product Name Abbreviation		EXCLUSIVES CUSTOMERS	EXCLUSIVES MONTH	Customer Name	Month	Product Name	Units
4	CNY	feb. 2023	Rosuva+Ezet		ABA	jan. 2023	ABA	feb. 2023	ESPIRONOLACTONA 100 MG - 60 COMP.	1
5			Amlod+Olme+Hctz		CNY	feb. 2023	ABA	feb. 2023	SINVASTATINA 20 MG - 60 COMP.	80
6			Metform+Vilda		DIL		ABA	feb. 2023	AMLODIPINA 10 mg - 60 Com	20
7							ABA	jan. 2023	PRAVASTATINA 20 MG - 60 COMP.	2
8							ABA	feb. 2023	NIFEDIPINA 20 MG - 60 COMP.	5
9							ABA	feb. 2023	SINVASTATINA 40 MG - 60 COMP.	2
10							ABA	feb. 2023	ROSUVASTATINA + EZETIMIBA 20 + 10 mg 60	4
11							ABA	jan. 2023	SERTRALINA 50 MG - 60 COMP.	24
12							ABA	jan. 2023	SERTRALINA 100 MG - 60 COMP.	20
13							ABA	feb. 2023	ROSUVASTATINA + EZETIMIBA 20 + 10 mg 60	16
14							CNY	feb. 2023	RAMIPRIL 2,5 MG - 56 CAPS.	2
15	RESULTS OF CRITERIA TABLE ABOVE						CNY	feb. 2023	RAMIPRIL 5 MG - 56 CAPS.	6
16	Product Name	Sum Units					CNY	feb. 2023	RAMIPRIL 10 MG - 56 CAPS.	6
17	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	70					CNY	feb. 2023	RAMIPRIL + HCTZ 5 MG/25 MG - 56 COMP.	1
18							CNY	feb. 2023	OLANZAPINA 2,5X28 MG	4
19							CNY	jan. 2023	PANTOPRAZOL 20 MG - 56 COMP.GASTRO-RESIST.	2
20							CNY	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	69
21							CNY	jan. 2023	MONTELUCASTE 10MG 28COMP	2
22							CNY	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	1
23							CNY	feb. 2023	PANTOPRAZOL 40 MG - 56 COMP.GASTRO-RESIST	2
24							CNY	jan. 2023	EBASTINA 10MG-20 COMP	6
25							DIL	feb. 2023	QUETIAPINA 25MG 20 COMP	12
26							DIL	feb. 2023	MONTELUCASTE 10MG 28COMP	2
27							DIL	feb. 2023	ESPIRONOLACTONA 25 MG - 60 COMP.	20
28							DIL	feb. 2023	METFORMINA + VILDAGLIPTINA 1000 + 50 mg 60	4
29							DIL	jan. 2023	CLOPIDOGREL GENERICOS 75MG 28C	50
30							DIL	feb. 2023	IRBESARTAN+HCTZ 150 12,5 28MG	4
31							DIL	jan. 2023	IRBESARTAN+HCTZ 300 12,5 28MG	2
32							DIL	feb. 2023	METFORMINA + VILDAGLIPTINA 1000 + 50 mg 60	3
Sheet1

Cell Formulas
Range	Formula
F4:F6	F4	=SORT(UNIQUE(H4:H32))
G4:G5	G4	=SORT(UNIQUE(I4:I32),,-1)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B5	List	=$G$4:$G$12
B4	List	=$F$4:$F$6
C4	List	=$G$4:$G$5

 

[Peter_SSs]

Should it help to clarify the goal?

Not exactly sure what you are asking.
Do either/both of the earlier suggestions do what you want?

 

[Lacan]

Dear @Peter_SSs
Please let my clarify because think this example maybe help other guys also with similar questions.

Through data in criteria Customer Name (cell B4) + Month (cell C4) + Product Name Abbreviation (cell D4) the goal is to filter Table DATA BASE (H4:K4) and to sum units accordingly.
In table RESULTS OF CRITERIA TABLE ABOVE (B11:C11) is a simple example of the end results from excel formula applied in the previous phrase.
To be more simple and noticeable just made a few ajustmens in all sheet.
Thanks for the help.

Search by Name_2.xlsm
	B	C	D	E	F	G	H	I	J	K
2	CRITERIA						DATA BASE
3	Customer Name	Month	Product Name Abbreviation		EXCLUSIVES CUSTOMERS	EXCLUSIVES MONTH	Customer Name	Month	Product Name	Units
4	CNY	feb. 2023	Amlod+Olme+Hctz		ABA	jan. 2023	ABA	feb. 2023	ESPIRONOLACTONA 100 MG - 60 COMP.	1
5					CNY	feb. 2023	ABA	feb. 2023	SINVASTATINA 20 MG - 60 COMP.	80
6					DIL		ABA	feb. 2023	AMLODIPINA 10 mg - 60 Com	20
7							ABA	jan. 2023	PRAVASTATINA 20 MG - 60 COMP.	2
8							ABA	feb. 2023	NIFEDIPINA 20 MG - 60 COMP.	5
9	RESULTS OF CRITERIA TABLE ABOVE		Still very very incomplete the formula below maybe could help for the correct one				ABA	feb. 2023	SINVASTATINA 40 MG - 60 COMP.	2
10	Product Name	Sum Units	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	69			ABA	feb. 2023	ROSUVASTATINA + EZETIMIBA 20 + 10 mg 60	4
11	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	70	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	1			ABA	jan. 2023	SERTRALINA 50 MG - 60 COMP.	24
12							ABA	jan. 2023	SERTRALINA 100 MG - 60 COMP.	20
13							ABA	feb. 2023	ROSUVASTATINA + EZETIMIBA 20 + 10 mg 60	16
14							CNY	feb. 2023	RAMIPRIL 2,5 MG - 56 CAPS.	2
15							CNY	feb. 2023	RAMIPRIL 5 MG - 56 CAPS.	6
16							CNY	feb. 2023	RAMIPRIL 10 MG - 56 CAPS.	6
17							CNY	feb. 2023	RAMIPRIL + HCTZ 5 MG/25 MG - 56 COMP.	1
18							CNY	feb. 2023	OLANZAPINA 2,5X28 MG	4
19							CNY	jan. 2023	PANTOPRAZOL 20 MG - 56 COMP.GASTRO-RESIST.	2
20							CNY	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	69
21							CNY	jan. 2023	MONTELUCASTE 10MG 28COMP	2
22							CNY	feb. 2023	AMLOD+OLME+HCTZ 5 MG +20 MG +12,5 MG 56	1
23							CNY	feb. 2023	PANTOPRAZOL 40 MG - 56 COMP.GASTRO-RESIST	2
24							CNY	jan. 2023	EBASTINA 10MG-20 COMP	6
25							DIL	feb. 2023	QUETIAPINA 25MG 20 COMP	12
26							DIL	feb. 2023	MONTELUCASTE 10MG 28COMP	2
27							DIL	feb. 2023	ESPIRONOLACTONA 25 MG - 60 COMP.	20
28							DIL	feb. 2023	METFORMINA + VILDAGLIPTINA 1000 + 50 mg 60	4
29							DIL	jan. 2023	CLOPIDOGREL GENERICOS 75MG 28C	50
30							DIL	feb. 2023	IRBESARTAN+HCTZ 150 12,5 28MG	4
31							DIL	jan. 2023	IRBESARTAN+HCTZ 300 12,5 28MG	2
32							DIL	feb. 2023	METFORMINA + VILDAGLIPTINA 1000 + 50 mg 60	3
Sheet2 (2)

Cell Formulas
Range	Formula
F4:F6	F4	=SORT(UNIQUE(H4:H32))
G4:G5	G4	=SORT(UNIQUE(I4:I32),,-1)
D10:E11	D10	=FILTER(J4:K32,ISNUMBER(SEARCH("*"&D4,J4:J32)))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B5	List	=$G$4:$G$12
B4	List	=$F$4:$F$6
C4	List	=$G$4:$G$5

 

[Peter_SSs]

As far as I can see, that is exactly what the suggestion in post #6 does. In what way does that method give the wrong answer?