Guys, need help from you Excel pros
Problem:
I have a list of users in 3 columns, first name, last name, cumulative number of logins for each user.
That list arrives every 1st of the month
Friend wants to know the number of logins for each month for every user.
That's not the problem, you just subtract cumulative number of logins from previous month to this month.
Problem is there are couple of new users being registered every month so i can't just do H1-C1 until the end of the list because one list will always have more users than the previous one.
Any idea how to do add new users to another list? Is there some IF check that if first/last name is not the same, copies that first/last name and login number, inserts a new row, pastes that into second list and just copies the data from first list to one row above (so 2 lists end up the same)?
Pic related, my table with dummy data