Wandem
07-11-2020, 02:24 PM
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
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