• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Last Processed Details reqd

W

webmax

Member
Hi

I have a raw date which contains emp code,name and Salary Processed date.

It contains all the raw data. I want the formula or macro to find up to what month the salary is processed.

I am attaching the sample for your reference

Example
1) If the Employee A salary is Processed from Jan 14 to May 14
2) If the Employee B salary is Processed from Jan 14 to Feb 14

For Employee A it showing the Processed month as May 14
For Employee B it showing the Processed month as Feb 14

Regards
Shahul
 

Attachments

  • last processed date.xlsx
    9.3 KB · Views: 9
In C2, confirm as array using Ctrl + Shift + Enter, not just Enter
=MAX((Data!$C$2:$C$12)*(Data!$A$2:$A$12=$A2))
Copy down as needed.
 
Hi Shahul,

Another option, confirm with Ctrl+Shift+Enter.
=LOOKUP(9.99999E+307,IF(B2=Data!$B$2:$B$12,Data!$C$2:$C$12))

Copy down.

Regards,
 
You must log in or register to reply here.
Back
Top