Matching Names
Hi,
I have a spreadsheet that contains a long list of staff names with data as follows: A B C Month Employee Name Monthly Salary From this list I want to create another 11 lists of monthly joiners and same for monthly leaversas follows: Monthly Joiners Lists: February Joiners March Joiners Employee Name Monthly Salary Employee Name Monthly Salary Under Employee Name I need a formulae that picks staff appear in February for the first time, and same applies for March, April, etc. Monthly Leavers Lists: February Leavers March Leavers Employee Name Monthly Salary Employee Name Monthly Salary Under Employee Name I need a formulae that picks staff appear in January for the last time, and same applies for March, April, etc. -- tarig |
All times are GMT +1. The time now is 08:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com