HI,
I need an excel formula to extract last allocation month based on criteria.
Query:
I have one allocation table with around 500 rows. Each rows is an employee month on month allocation in a program.
My query is that I need a formula in Table-2 which shows Last Allocation month based on Employee no and program name entered.
Sample sheet attached for your reference
Thanks
Nitesh
Try
Please Login or Register to view this content.
Try this
ARRAY formula in D14 then drag down.
Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 03-19-2019 at 04:28 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Both Emp id and Name are required so just matching $A14 is not enough.Originally Posted by kvsrinivasamurthy
Since range $D$3:$O$3 contains only sorting numbers then it's safe to try
Edit: If range $D$3:$O$8 contains text then tryPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by congnt92; 03-19-2019 at 05:29 AM.
In D14 then drag down
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks