Hello there,
I can't seem to find or even know what to search for to find a solution to my problem, so I went with creating this thread.
If it's a duplicate, I'm sorry about this and you can point me to a thread that already has the solution and I'll get rid of this one.
I'm trying to find the number of logged users on a ranged date by month, here's a simple example of a table:
So, I need a formula that will calculate the number of login attempts, for instance, of user A for each month and then for user B and each month and so on.
These results would need to be displayed on a 3rd column along the table according the user and month.
Is this even doable without using VBA?
Thanks in advance.
P.S. I forgot to mention that I'm using Office 365, which is equivalent for Excel 2016 if not mistaken.
I can't seem to find or even know what to search for to find a solution to my problem, so I went with creating this thread.
If it's a duplicate, I'm sorry about this and you can point me to a thread that already has the solution and I'll get rid of this one.
I'm trying to find the number of logged users on a ranged date by month, here's a simple example of a table:
So, I need a formula that will calculate the number of login attempts, for instance, of user A for each month and then for user B and each month and so on.
These results would need to be displayed on a 3rd column along the table according the user and month.
Is this even doable without using VBA?
Thanks in advance.
P.S. I forgot to mention that I'm using Office 365, which is equivalent for Excel 2016 if not mistaken.