Patcheen
Active Member
- Joined
- Sep 28, 2015
- Messages
- 388
- Office Version
- 365
- Platform
- Windows
How can i find the minimum date? from the employee sheet?
column A in the employee sheet is the name that B2 has to match and column D in the employee sheet is the date that i want so how can i get this?
what i have but not working is :
=MIN('Employee sheet'!$A$2:$A$10000,B2,('Employee sheet'!$D$2:$D$10000))
column A in the employee sheet is the name that B2 has to match and column D in the employee sheet is the date that i want so how can i get this?
what i have but not working is :
=MIN('Employee sheet'!$A$2:$A$10000,B2,('Employee sheet'!$D$2:$D$10000))