Hi All,
New here, I have scoured these forums and others trying to get an answer to my task.
I have a SS that has a date(col a),name(col b) and contact number(col c) that we use as a reference to a roster.
I can extract the name and number based on the date , what I am hoping to do is show the date when the roster changes.
In the example below Fred is on roster today, 20/07/2020, and Dan is to start on 22/07/2020.
On the main roster I want to show that Fred is on roster until 21/07/2020 when Dan takes over.
I have looked at match and index functions but can't get them
New here, I have scoured these forums and others trying to get an answer to my task.
I have a SS that has a date(col a),name(col b) and contact number(col c) that we use as a reference to a roster.
I can extract the name and number based on the date , what I am hoping to do is show the date when the roster changes.
In the example below Fred is on roster today, 20/07/2020, and Dan is to start on 22/07/2020.
On the main roster I want to show that Fred is on roster until 21/07/2020 when Dan takes over.
I have looked at match and index functions but can't get them
20/07/2020 | Fred Bloggs | 0400 000 111 |
21/07/2020 | Fred Bloggs | 0400 000 111 |
22/07/2020 | Dan Dare | 0400 111 111 |
23/07/2020 | Dan Dare | 0400 111 111 |
24/07/2020 | Dan Dare | 0400 111 111 |
25/07/2020 | Dan Dare | 0400 111 111 |
26/07/2020 | Dan Dare | 0400 111 111 |
27/07/2020 | Dan Dare | 0400 111 111 |
28/07/2020 | Dan Dare | 0400 111 111 |
29/07/2020 | Stan Smith | 0400 222 111 |
30/07/2020 | Stan Smith | 0400 222 111 |
31/07/2020 | Stan Smith | 0400 222 111 |
1/08/2020 | Stan Smith | 0400 222 111 |
2/08/2020 | Stan Smith | 0400 222 111 |