EXCEL PROBLEM

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

Attached: First position.jpg (1035x362, 93K)

Install Gentoo

Make a Pivot Table.

How would pivot help me?

Welp, after rereading your question I think it won't.

What I'd do is interact with the spreadsheet using an external programming languge. I'd either use bash/ssconvert/awk or python or something microsofty with good Excel integration. That might just be me hating to work on spreadsheets tho.

Is there at least some function that searches the whole first list and subtracts number of logins from the second list is there is a matching first and last name? for those new users i would have to do things manually

You could try doing something with VLOOKUP.

Formatted table, then use structured references.

Query your database and filter by time stamp.

>excel
Thats the problem