-
Count number of users active each month
Hello,
I have a table with a list of users active in a system. There are the date that user was registered and the date that user was disabled. If the user was not disabled, than it`s active. I need a table summarizing number of user, per company, per month. How do I do this using VBA?
Thanks for any help.
I have data like this
ID user |
User active |
Register date |
Date of exclusion |
Company |
10 |
n |
01052020 |
10062020 |
Beer |
11 |
y |
01032020 |
|
Cat |
12 |
y |
01052020 |
|
Cat |
13 |
y |
01042020 |
|
Beer |
14 |
n |
01062020 |
01072020 |
Beer |
Table generated in 07152020
I would like to have a table like this
Company |
Month |
Number of users |
Beer |
032020 |
0 |
Beer |
042020 |
1 |
Beer |
052020 |
2 |
Beer |
062020 |
3 |
Beer |
072020 |
2 |
Cat |
032020 |
1 |
Cat |
042020 |
1 |
Cat |
052020 |
2 |
Cat |
062020 |
2 |
Cat |
072020 |
2 |
|
|
|
Last edited by Wandem; 07-11-2020 at 03:55 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules