Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching names and combining worksheets | Excel Discussion (Misc queries) | |||
Matching names | Excel Discussion (Misc queries) | |||
Matching names in two columns | Excel Discussion (Misc queries) | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
Matching Names in two different workbooks | Excel Discussion (Misc queries) |