Jun 03 2021 06:19 PM
Hi All,
I have a spreadsheet which includes large sets of data, showing an account and the person responsible (managers) for it across many months. We wish to show some reporting on the number of accounts and managers. For each month i need to count the number of accounts/managers which have a value greater than $0.00, and show those which are added.
Whilst my spreadsheet is very large and doing this manually is very time consuming, i am hoping to use a formula to work this out for me. Once an account is new, it will have a positive balance, and have not previously had an account value.
If anyone has any ideas on how to do this, it would be very much appreciated. I have included some sample data and workings.
Many thanks,
Jun 04 2021 01:04 AM
Jun 06 2021 10:07 PM
SolutionJun 07 2021 04:42 AM
Check the attached WB, and the read the instruction also. I do believe that is what you were looking for,, in case of any further issue,, do reply this post,,, and if my suggested method works for you then you may accept it as best answer as well like.
Jun 07 2021 06:40 PM
Jun 08 2021 03:34 AM
Jun 08 2021 05:45 PM
Jun 06 2021 10:07 PM
Solution