Min Date

Patcheen

Active Member
Joined
Sep 28, 2015
Messages
388
Office Version
  1. 365
Platform
  1. 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))
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
a2:a1000 and b2:d10000 hope thats right..... ive to put kids bed so be a while b4 i check back later
 
Upvote 0
Yes at A2 to a1000 corresponding dates are in b2:b1000
 
Upvote 0
Yes at A2 to a1000 corresponding dates are in b2:b1000

Jeff has already provided the formula that should work, that is, control+shift+enter, not just enter...

=MIN(IF($A$2:$A$1000=$E2,$B$2:$B$1000)

where E2 houses an employee of interest.

Adding some audit, still control+shift+enter...

=IF(COUNTIFS($A$2:$A$1000,$E2),MIN(IF($A$2:$A$1000=$E2,$B$2:$B$1000)),"")

If you don't still get the correct result (you claimed getting 0). If this is still the case, we will some diagnostics...
 
Upvote 0
Jeff has already provided the formula that should work, that is, control+shift+enter, not just enter...

=MIN(IF($A$2:$A$1000=$E2,$B$2:$B$1000)

where E2 houses an employee of interest.

Adding some audit, still control+shift+enter...

=IF(COUNTIFS($A$2:$A$1000,$E2),MIN(IF($A$2:$A$1000=$E2,$B$2:$B$1000)),"")

If you don't still get the correct result (you claimed getting 0). If this is still the case, we will some diagnostics...


Don't try at all anything. You first need to decide what is the FROM sheet and what is the TO sheet. Put othwerwise: FROM = source, TO = destination.

The FROM sheet is the sheet from which the min date must come for the name that is in the TO sheet.

Would you state which sheet of yours, Employee or Attandance, is the FROM (source) sheet?
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,937
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top