Most Recent Date

zinah

Board Regular
Joined
Nov 28, 2018
Messages
179
Office Version
  1. 365
Platform
  1. Windows
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 DateMost 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
Joined
Dec 7, 2013
Messages
110
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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:E6E2=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
ABCDE
1EE IDLast Modified DateUNIQUE IDMost Recent Update Date Per Employee
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.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,114,314
Messages
5,547,159
Members
410,775
Latest member
alal1030
Top