Most Recent Date

[zinah]

Hi,

I have list of employees with their goals, each employee has at least 3 goals and each goal has a different update goal date. My question is how to figure out the most recent update date of each employee? What is the right formula?
Below is a sample of employees list:

EE ID​	Last Modified Date	Most Recent Update Date Per Employee
1111​	6/10/2020
1111​	6/10/2020
1111​	6/10/2020
1111​	6/10/2020
1111​	7/13/2020
1111​	6/10/2020
2222​	2/28/2020
2222​	7/18/2020
2222​	7/18/2020
2222​	7/18/2020
2222​	7/18/2020
2222​	7/18/2020
2222​	7/18/2020
2222​	7/18/2020
3333​	2/26/2020
3333​	2/26/2020
3333​	2/26/2020
3333​	2/26/2020
3333​	2/26/2020
3333​	2/26/2020
4444​	6/25/2020
4444​	6/25/2020
4444​	6/25/2020
4444​	6/25/2020
4444​	6/25/2020
4444​	6/25/2020
4444​	6/25/2020
4444​	6/25/2020
4444​	6/25/2020
5555​	6/22/2020
5555​	6/22/2020
5555​	6/22/2020
5555​	6/22/2020
5555​	6/22/2020
5555​	6/22/2020

Thank you!

 

[KevCarter]

No worries, I tried to figure out the unique ID issue and it worked, however, when I'm trying to mimic your below formula I couldn't understand what the symbol "#" stands for?

2:E6

E2

=IF(D2="","",MAXIFS($B$2:$B$36,$A$2:$A$36,D2#))

Using the # symbol will only work on ranges created by the new dynamic array formulas, such as UNIQUE. This formula will work in 365 when creating a range of unique items in a different manner...

MaxIfs Answer.xlsx
	A	B	C	D	E
1	EE ID	Last Modified Date		UNIQUE ID	Most Recent Update Date Per Employee
2	1111	6/10/20		1111	7/13/20
3	1111	6/10/20		2222	8/8/20
4	1111	6/10/20		3333	2/26/20
5	1111	6/10/20		4444	6/25/20
6	1111	7/13/20		5555	6/24/20
7	1111	6/10/20
8	2222	2/28/20
9	2222	7/18/20
10	2222	7/18/20
11	2222	8/8/20
12	2222	7/18/20
13	2222	7/18/20
14	2222	7/18/20
15	2222	7/18/20
16	3333	2/26/20
17	3333	2/26/20
18	3333	2/26/20
19	3333	2/26/20
20	3333	2/26/20
21	3333	2/26/20
22	4444	6/25/20
23	4444	6/25/20
24	4444	6/25/20
25	4444	6/25/20
26	4444	6/25/20
27	4444	6/25/20
28	4444	6/25/20
29	4444	6/25/20
30	4444	6/25/20
31	5555	6/22/20
32	5555	6/22/20
33	5555	6/24/20
34	5555	6/22/20
35	5555	6/22/20
36	5555	6/22/20
Sheet1

Cell Formulas
Range	Formula
E2:E6	E2	=IF(D2="","",MAXIFS($B$2:$B$36,$A$2:$A$36,D2:D6))
Dynamic array formulas.