# Most Recent Date

#### zinah

##### Board Regular
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

##### Board Regular
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...

ABCDE
211116/10/2011117/13/20
311116/10/2022228/8/20
411116/10/2033332/26/20
511116/10/2044446/25/20
611117/13/2055556/24/20
711116/10/20
822222/28/20
922227/18/20
1022227/18/20
1122228/8/20
1222227/18/20
1322227/18/20
1422227/18/20
1522227/18/20
1633332/26/20
1733332/26/20
1833332/26/20
1933332/26/20
2033332/26/20
2133332/26/20
2244446/25/20
2344446/25/20
2444446/25/20
2544446/25/20
2644446/25/20
2744446/25/20
2844446/25/20
2944446/25/20
3044446/25/20
3155556/22/20
3255556/22/20
3355556/24/20
3455556/22/20
3555556/22/20
3655556/22/20
Sheet1
Cell Formulas
RangeFormula
E2:E6E2=IF(D2="","",MAXIFS(\$B\$2:\$B\$36,\$A\$2:\$A\$36,D2:D6))
Dynamic array formulas.

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Replies
8
Views
77
Replies
7
Views
58
Replies
2
Views
83
Replies
1
Views
71
Replies
3
Views
65