Hi Again Community this is my second question today but i'd rather ask and learn from you guys than struggle and get nowhere.
I have a list of people and there balances for January and December but I know for certain that some clients have a January balance and not a December balance and vice versa. I'm just wondering how would I check if a person has both a Jan and Dec balance or just one of them.
I've attached a dummy sample below of my actual data:
Code | Name | Month | Total |
1 | Joe | January | 1893.65 |
2 | Tom | January | 1815 |
3 | Tom | December | 17736.6 |
4 | Mary | December | 22060.5 |
5 | Liam | January | 22990 |
6 | James | January | 6789 |
7 | James | December | 3678 |
8 | Ava | January | 900 |
9 | Ava | December | 6000 |
10 | John | Janaury | 10000 |
Solved! Go to Solution.
@Deano478 , You can use summarize tool to get the count of months corresponding to each Name as below:
@Felipe_Ribeir0 @binuacs @grazitti_sapna @gautiergodard Hi guys sorry for late response I looked at each of your methods and they are all very different but interesting to see how something can be done so many different ways thank you all I learned something new today