contraububu
New Member
- Joined
- Nov 18, 2013
- Messages
- 17
Can someone help me with the following scenario? I would like to find an excel formula that would give me for any changes in the "Name" column, count how many occurrence in the "Effective Date" for that name and display it as Day 1, Day 2, Day 3 etc. or just simply give me the count. Much appreciate your help!
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Name | Effective Date | Excel Formula |
Michael | 09/15/2016 | Day 1 |
Michael | 04/01/2016 | Day 2 |
Michael | 09/08/2014 | Day 3 |
Frank | 10/16/2015 | Day 1 |
Edmond | 10/16/2015 | Day 1 |
Lina | 04/01/2016 | Day 1 |
Lina | 09/01/2015 | Day 2 |
Laura | 04/01/2016 | Day 1 |
Laura | 02/23/2015 | Day 2 |
Robert | 04/01/2016 | Day 1 |
Robert | 12/01/2015 | Day 2 |
Steven | 12/14/2015 | Day 1 |
Brittany | 04/01/2016 | Day 1 |
Brittany | 11/01/2016 | Day 2 |
Mitchell | 10/31/2016 | Day 1 |
Mitchell | 04/01/2016 | Day 2 |
Mitchell | 11/01/2015 | Day 3 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>