Sumif / Max type of formula

[gheyman]

I need a formula that looks for a match for my Cell C11 in a table named "CMCS_BoM_MakeTable" column named "TASK ID" and find the Min Date in the tables column named "Cost From Date"

Thank you for your time and help.

 

[Fluff]

You can use the MINIFS function for that. It works the same as the other xxxIFS functions.

 

[gheyman]

My "Cost From Date" may contain blanks which I dont want in my results.

 

[gheyman]

You can use the MINIFS function for that. It works the same as the other xxxIFS functions.

Thanks, Fluff. I just realized that its possible for my date column to have blanks in it. Any way around that?

 

[Fluff]

In that case please post some sample data.

 

[gheyman]

Example:

Tab 1 in Cell A1 = 0001MATL

I want to find the Min Date for 0001MATL

TASK ID	Cost From Date	Cost To Date
0001MATL	1/1/2024	2/25/2024
0001MATL	12/02/2023	1/18/2024
0001MATL
0002MATL	5/1/2023	8/1/2023

 

[Fluff]

Thanks for that. How about

Fluff.xlsm
	A	B	C	D	E	F
1	TASK ID	Cost From Date	Cost To Date
2	0001MATL	01/01/2024	25/02/2024		0001MATL	02/12/2023
3	0001MATL	02/12/2023	18/01/2024
4	0001MATL
5	0002MATL	01/05/2023	01/08/2023
Sheet6

Cell Formulas
Range	Formula
F2	F2	=MINIFS(B:B,B:B,">0",A:A,E2)

 

[gheyman]

Thanks. That worked and sorry for the delayed response. I was temporarily pulled onto a different project.

 

[Fluff]

You're welcome & thanks for the feedback.