Find last date

[Solomon14all]

HI EVERY ONE

HOW WILL FIND OUT ANSWER FOR THE BELOW GIVE 2 QUESTION

1. IF PROJECT NO # 001 FIND THE START DATE
2. IF PROJECT NO # 001 FIND THE END DATE

CHECK THE ATTACHMENT

THANKS IN ADVANCE




PROJECT NO EMP. ID NOW DAYS DATE RUN HRS JS DT
001 113 1 1.00 8.00 1-Sep-12
001 113 0 1.00 9.00 1-Sep-12
001 117 1 8.00 17.00 1-Sep-12
001 122 1 8.00 25.00 1-Sep-12
500 229 1 5.00 30.00 1-Sep-12
001 103 1 3.00 3.00 2-Sep-12
001 122 1 5.00 8.00 2-Sep-12
001 177 1 - 8.00 2-Sep-12
004 113 1 9.00 17.00 2-Sep-12
004 103 0 6.00 23.00 2-Sep-12
011 103 1 - 3-Sep-12
004 117 1 7.00 7.00 3-Sep-12
001 113 1 7.00 3-Sep-12
001 113 0 7.00 3-Sep-12
001 117 0 7.00 3-Sep-12
001 122 1 - 4-Sep-12
500 229 1 - 4-Sep-12
001 103 1 - 4-Sep-12

[Jakobshavn]

If the project IDs are in column A and the dates are in column F, then the array formula:

=MAX(IF(A1:A100=1,F1:F100)) formatted as Date will display the latest date for project 1

This is an array formula that must be entered with CNTRL-SHFT-ENTER rather than just the ENTER key

[Fotis1991]

..Same question here?

http://www.excelforum.com/excel-gene...-employee.html

[Solomon14all]

Dear Jakobshavn,

Thanks a lot

Regards,
Raj.