How to check if a person has both a January and December balance or not

[Deano478]

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

[Felipe_Ribeir0 · Accepted solution]

Hi @Deano478 

One way of doing this

[binu_acs · Accepted solution]

@Deano478 One way of doing this

[grazitti_sapna]

@Deano478 , You can use summarize tool to get the count of months corresponding to each Name as below:

[gautiergodard]

Hey @Deano478 

Yet another way to approach this one, with a few less tools! 

Enjoy!

[Deano478]

@Felipe_Ribeir0 @binu_acs @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