Nitesh Mathur
Member
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
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