Select latest dates from one column based on set of values

[Monty9]

Hello Gurus,

I request your help in the scenario where I have 3 Columns (example in attachment) - Now I need to run a check based on Column A (Plan) which shall have duplicate values and a large list, based on Column A wherever I have a Latest Completion date it should be captured in Column C. I've given the demo results in attachment.

If there are no Completion Date then result can be 'Blank Result'

Thanks

 

[Peter_SSs]

In future you will generally get better/faster resonses if you provide sample data in a form that helpers can easily copy to test with.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

See if this helps.

22 04 14.xlsm
	A	B	C
1
2	8300
3	8300		Blank Result
4	8301
5	8301
6	8301	8/12/2020	8/12/2020
7	16908	7/02/2022
8	16908	14/12/2021
9	16908	13/10/2021
10	16908	18/08/2021	7/02/2022
11
Latest

Cell Formulas
Range	Formula
C2:C10	C2	=IF(A2=A3,"",LET(dte,MAXIFS(B$2:B2,A$2:A2,A2),IF(dte=0,"Blank Result",dte)))

 

[Monty9]

Hello Gurus,

I request your help in the scenario where I have 3 Columns (example in attachment) - Now I need to run a check based on Column A (Plan) which shall have duplicate values and a large list, based on Column A wherever I have a Latest Completion date it should be captured in Column C. I've given the demo results in attachment.

If there are no Completion Date then result can be 'Blank Result'

Thanks

I tried with =MAXIFS() and it worked!

 

[Monty9]

In future you will generally get better/faster resonses if you provide sample data in a form that helpers can easily copy to test with.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

See if this helps.

22 04 14.xlsm
	A	B	C
1
2	8300
3	8300		Blank Result
4	8301
5	8301
6	8301	8/12/2020	8/12/2020
7	16908	7/02/2022
8	16908	14/12/2021
9	16908	13/10/2021
10	16908	18/08/2021	7/02/2022
11
Latest

Cell Formulas
Range	Formula
C2:C10	C2	=IF(A2=A3,"",LET(dte,MAXIFS(B$2:B2,A$2:A2,A2),IF(dte=0,"Blank Result",dte)))

Thank you Peter

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.