Multiple conditions and min data search

[Bazabelle]

I want to first be sorry for the image, I tried the XL2BB but microsoft blocks it and I cannot use it.

In the image 1 I have added the table I would like to fill and the formula I am searching. The image 2 is the sheet where the raw data is.

Q1 - I want for the country in Sheet 1 to find the min value in column E or G of that country in Sheet 2​

​

Q2 - I want to count for the country in Sheet 1 all the rows that includes a date for that country in Sheet 2 for Column F​

Hope this make sense, thank you in advance

 

[Bazabelle]

I think you confused my answer. In my formula I do not have the symbol <>

It would help if you put the expected results, since the columns in image 1 are empty and I am assuming where you want the result of Q1 and where you want the result of Q2.

Correct, but if I use your formula as is, it is not working, so I tried alternatives.

 

[Bazabelle]

Test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	ID number	Country	Name	Department	Data 1 Submission Baseline	Data 1 Submission Planned	Data 1 Submission Actual	Data 1 Approval Baseline	Data 1 Approval Planned	Data 1 Approval Actual	Data 2 Submission Baseline	Data 2 Submission Planned	Data 2 Submission actual	Data 2 Approval Baseline	Data 2 Approval Planned	Data 2 Approval Actual	Data 3 Submission baseline	Data 3 Submission Planned	Data 3 Submission Actual	Data 3 Approval Baseline	Data 3 Approval Planned	Data 3 Approval Actual	Data 4 Submission Baseline	Data 4 Submission Planned	Data 4 Submission Actual	Data 4 Approval Baseline	Data 4 Approval Planned	Data 4 Approval Actual
2		France	ABC	1	3-Mar-23	3-Mar-23	15-Mar-23	-	-	-	1-Jan-23	1-Jan-23	9-Jan-23	Please select	Please select	Please select	Please select	Please select	Please select				Please select	Please select	Please select	Please select
3		France	DEF	2	Please select	Please select	Please select	10-May-22	13-May-22	13-May-22	14-Apr-23	14-Apr-23		Please select	Please select	Please select	13-May-22	13-May-22	13-May-22
4		Canada	GHI	3	1-Apr-23	1-Apr-23	1-Apr-23	-	-	-	-	6-May-23	12-Apr-23	Please select	Please select	Please select	23-Apr-23	23-Apr-23	24-Apr-23
5		Canada	JKL	4	-	-	18-Jan-23	28-Mar-23	28-Mar-23	28-Mar-23	12-Jan-23	12-Jan-23	1-Jan-23	Please select	Please select	Please select	1-Apr-23	1-Apr-23					Please select	Please select	Please select	Please select
6		Japan	MNO	5	-	-	29-Sep-22	15-Oct-22	15-Oct-22	31-Oct-22	15-Sep-22	15-Sep-22	15-Sep-22	Please select	Please select	Please select	18-Jan-23	18-Jan-23	18-Jan-23
7		Canada	PQR	6	Please select	Please select	Please select	Please select	Please select	Please select	Please select	15-Mar-23	15-Mar-23	Please select	Please select	Please select	9-Sep-22	9-Sep-22	29-Sep-22	Please select	Please select	Please select
8		France	ABC	1	13-May-22	13-May-22	13-May-22	2-Jun-22	17-Jun-22	17-Jun-22	1-Jan-23	1-Jan-23	9-Jan-23	Please select	Please select	Please select	Please select	Please select	Please select
9		France	DEF	2	23-Apr-23	23-Apr-23	24-Apr-23	6-May-23	17-May-23	17-May-23	14-Apr-23	14-Apr-23		Please select	Please select	Please select	Please select	Please select	Please select				Please select	Please select	Please select	Please select
10		Canada	GHI	3	1-Apr-23	1-Apr-23		15-Aug-23	15-Aug-23		6-May-23	6-May-23	12-Apr-23	Please select	Please select	Please select	1-Jan-23	1-Jan-23	9-Jan-23
11		Canada	JKL	4	18-Jan-23	18-Jan-23	18-Jan-23	-	-	-	-	12-Jan-23	1-Jan-23	Please select	Please select	Please select	14-Apr-23	14-Apr-23
12		Japan	MNO	5	9-Sep-22	9-Sep-22	29-Sep-22	-	-	-	-	15-Sep-22	15-Sep-22	Please select	Please select	Please select	6-May-23	6-May-23	12-Apr-23	Please select	Please select	Please select
13		Canada	PQR	6	Please select	Please select	Please select	Please select	Please select	Please select	Please select	15-Mar-23	15-Mar-23	Please select	Please select	Please select	-	12-Jan-23	1-Jan-23				Please select	Please select	Please select	Please select
14		France	ABC	1	2-Mar-23	3-Mar-23	15-Mar-23	14-Jul-23	14-Jul-23		1-Jan-23	1-Jan-23	9-Jan-23	Please select	Please select	Please select	-	15-Sep-22	15-Sep-22
15		France	DEF	2	Please select	Please select	Please select	Please select	Please select	Please select	Please select	14-Apr-23		Please select	Please select	Please select	Please select	15-Mar-23	15-Mar-23
16		Canada	GHI	3	28-Mar-23	1-Apr-23	9-May-23	15-Jun-23	15-Jun-23	9-Jun-23	6-May-23	6-May-23	12-Apr-23	Please select	Please select	Please select	1-Jan-23	1-Jan-23	9-Jan-23	Please select	Please select	Please select
17		Canada	JKL	4	17-Apr-23	18-Jan-23	18-Jan-23	5-Feb-23	5-Feb-23	2-Feb-23	12-Jan-23	12-Jan-23	1-Jan-23	Please select	Please select	Please select	Please select	14-Apr-23
18		Japan	MNO	5	31-Aug-22	9-Sep-22	29-Sep-22	28-Oct-22	31-Oct-22	1-Nov-22	15-Sep-22	15-Sep-22	15-Sep-22	Please select	Please select	Please select	6-May-23	6-May-23	12-Apr-23
19		Canada	PQR	6	31-Mar-23	31-Mar-23	15-Apr-23	15-Aug-23	7-Aug-23		15-Mar-23	15-Mar-23	15-Mar-23	Please select	Please select	Please select	12-Jan-23	12-Jan-23	1-Jan-23
Raw data

Test.xlsx
	A	B	C
1	Country	DATA 1 count Planned	DATA 1 Count Actual
2	Canada
3	France
4	Japan
Country Submission counts

Test.xlsx
	A	B	C	D	E
1	Country	DATA 1 +3 Submission Planned	DATA 1 +3 Submission Actual	DATA 2 Submission Planned	DATA 2 Submission Actual
2	Canada
3	France
4	Japan
Country Submission Dates

I hope this will give a better view of what I am trying to get.

 

[kweaver]

What are your expected answers?

 

[Bazabelle]

What are your expected answers?

Test.xlsx
	A	B	C	D	E
1	Country	DATA 1 +3 Submission Planned	DATA 1 +3 Submission Actual	DATA 2 Submission Planned	DATA 2 Submission Actual
2	Canada	9-Sep-22	29-Sep-22	12-Jan-23	1-Jan-23
3	France	13-May-22	13-May-22	1-Jan-23	9-Jan-23
4	Japan	9-Sep-22	29-Sep-22	15-Sep-22	15-Sep-22
Country Submission Dates

Test.xlsx
	A	B	C
1	Country	DATA 1 count Planned	DATA 1 Count Actual
2	Canada	9	5
3	France	6	4
4	Japan	3	2
Country Submission counts