JonRowland
Active Member
- Joined
- May 9, 2003
- Messages
- 415
- Office Version
- 365
- Platform
- Windows
I'm going to try my best at explaining this as not coming acrosss well in my head.
What I is to conduct a Count of values within Col Z which to include first & last Date (Col A) they appear and last. However the values in Col Z may change at some point but may revert back to the original value at some point. When they revert back I won't the count to restart for this second period.
I want to do this within my VBA project
So Data something like
Result I would like on a new WkSht
What I is to conduct a Count of values within Col Z which to include first & last Date (Col A) they appear and last. However the values in Col Z may change at some point but may revert back to the original value at some point. When they revert back I won't the count to restart for this second period.
I want to do this within my VBA project
So Data something like
Col A | Col Z |
01/01/2020 | abcd |
02/01/2020 | abcd |
03/01/2020 | fghy |
04/01/2020 | fghy |
05/01/2020 | fghy |
06/01/2020 | abcd |
07/01/2020 | abcd |
08/01/2020 | fghy |
Result I would like on a new WkSht
abcd | 2 | 01/01/2020 | 02/01/2020 |
fghy | 3 | 03/01/2020 | 05/01/2020 |
abcd | 2 | 06/01/2020 | 07/01/2020 |
fghy | 1 | 08/01/2020 | 08/01/2020 |