A | B | C | D | E | F | G | H | |
1 | Staff Member | Start Date | Table1 (2).First Name | Table1 (2).Surname | Table1 (2).Employment Status | Table1 (2).Position Number | Table1 (2).Position Number2 | Table1 (2).Position End |
2 | 100518 | 7/1/2017 | Simon | Phillips | FULL-TIME EMPLOYEE | EXD004 | Administration Manager | 12/10/2019 |
3 | 100519 | 7/1/2018 | Jodie | North | FULL-TIME EMPLOYEE | GMLSI2 | GM - Marketing | 12/10/2019 |
4 | 100526 | 7/1/2019 | Michelle | Mackay | FULL-TIME EMPLOYEE | LDM003 | Assistant Manager | 7/14/2019 |
5 | 100532 | 3/23/2020 | Cecelia | Simpson | PART-TIME EMPLOYEE | AS008A | Associate | 6/19/2020 |
6 | 100533 | 12/11/2019 | Sheree | Arnold | FULL-TIME EMPLOYEE | NPL003 | NPLeader | 6/19/2020 |
7 | 100535 | 8/22/2019 | James | Arbot | PART-TIME EMPLOYEE | MAT202 | GM - Major | 2/28/2020 |
8 | 100544 | 6/22/2019 | Emma | Crouch | PART-TIME EMPLOYEE | GMNO01 | GM - QLD (North QLD) | 6/19/2020 |
9 | 100546 | 12/5/2019 | Sophie | McDonald | FULL-TIME EMPLOYEE | NPLAL1 | NPL North | 6/19/2020 |
10 | 100559 | 7/30/2018 | Bianca | Best | PART-TIME EMPLOYEE | AUT106 | Law Clerk | 1/27/2020 |
11 | 100568 | 4/18/2016 | Kerri-Dee | Grimason | PART-TIME EMPLOYEE | QPO001 | SST Billing Operator | 1/31/2020 |
12 | 100571 | 1/20/2020 | Christine | Smith | FULL-TIME EMPLOYEE | AUT801 | Law Clerk | 1/20/2021 |
13 | 100584 | 1/24/2020 | Rebecca | Smith | FULL-TIME EMPLOYEE | MAT219 | LPM - Vic | 7/31/2020 |
14 | 100589 | 11/9/2019 | Karen | Lesser | PART-TIME EMPLOYEE | KMC001 | Knowledge Management Coordinator | 12/12/2019 |
Hi AliGW, sorry it is when their Position Title changes in Column F.How would I know that their position had changed?
Hi AliGW, sorry it is when their Position Title changes in Column F.How would I know that their position had changed?
Hi Alan,Using Power Query, I created the following which shows the latest position for each EE. If this is an acceptable presentation, post back and I will take you through the steps to achieve this.
Data Range
A B C D E F G H 1 Staff Member Start Date Table1 (2).First Name Table1 (2).Surname Table1 (2).Employment Status Table1 (2).Position Number Table1 (2).Position Number2 Table1 (2).Position End 2 100518 7/1/2017 Simon Phillips FULL-TIME EMPLOYEE EXD004 Administration Manager 12/10/2019 3 100519 7/1/2018 Jodie North FULL-TIME EMPLOYEE GMLSI2 GM - Marketing 12/10/2019 4 100526 7/1/2019 Michelle Mackay FULL-TIME EMPLOYEE LDM003 Assistant Manager 7/14/2019 5 100532 3/23/2020 Cecelia Simpson PART-TIME EMPLOYEE AS008A Associate 6/19/2020 6 100533 12/11/2019 Sheree Arnold FULL-TIME EMPLOYEE NPL003 NPLeader 6/19/2020 7 100535 8/22/2019 James Arbot PART-TIME EMPLOYEE MAT202 GM - Major 2/28/2020 8 100544 6/22/2019 Emma Crouch PART-TIME EMPLOYEE GMNO01 GM - QLD (North QLD) 6/19/2020 9 100546 12/5/2019 Sophie McDonald FULL-TIME EMPLOYEE NPLAL1 NPL North 6/19/2020 10 100559 7/30/2018 Bianca Best PART-TIME EMPLOYEE AUT106 Law Clerk 1/27/2020 11 100568 4/18/2016 Kerri-Dee Grimason PART-TIME EMPLOYEE QPO001 SST Billing Operator 1/31/2020 12 100571 1/20/2020 Christine Smith FULL-TIME EMPLOYEE AUT801 Law Clerk 1/20/2021 13 100584 1/24/2020 Rebecca Smith FULL-TIME EMPLOYEE MAT219 LPM - Vic 7/31/2020 14 100589 11/9/2019 Karen Lesser PART-TIME EMPLOYEE KMC001 Knowledge Management Coordinator 12/12/2019
I just think it is great that we can network with people from all over the world & it brings it home a bit more when we see what's happening around the world, if that makes sense. Obviously not faces to names, but it just makes it seem a bit more real. I've been working from home for about 4 months I think oblivious to some of the things that are going on.Kelli
My primary home is in Steamboat Springs, CO.
I also have a summer place in Litchfield, ME.
Why do you ask?