Finding the count of first appearance and repeat visits

[jarust91]

Hello,

I have a table that contain all of our programs user names and month of use. Throughout the table there are instances where a name is repeated signifying a repeat use of the program. I am trying to find a way to be able to see the total number of "repeat users" in any given month. Additionally, I want to be able to find a way to see the total number of "first time users" in any given month.

I have created a pivot table where the name is the row and the month is the column. I then showed "count of name" in the pivot table. I am not certain if this is the right course of action, or if there is another way to do this. I tried to upload pictures of the pivot table and the regular table, but I can't seem to be able to figure it out.

Thank you for any help that can be provider

 

[NiMip]

Is the table below something like what you're after? Involves adding another column to your dataset, and the second table on the right could be a pivottable as you described in your original post, if you'd prefer.
In my scenario, a person is a first-timer the first time they login, and a repeat for any future logins. If you want to find single-time users it would be a slightly different solution.

	Name	Login Month	First-timer or Repeat?		Month	First-timer <tbody> </tbody>	Repeat
	Jane	Jan-15	=IF(COUNTIFS($C$3:$C$17,"<"&C3,$B$3:$B$17,B3)=0,"First-timer","Repeat")		Jan-15	=COUNTIFS($D$3:$D$17,G$2,$C$3:$C$17,$F3)	=COUNTIFS($D$3:$D$17,G$2,$C$3:$C$17,$F3)
	Jeff	Jan-15	First-timer		Feb-15	3	1
	John	Jan-15	First-timer		Mar-15	1	3
	Joe	Jan-15	First-timer		Apr-15	1	2
	Jess	Feb-15	First-timer
	Joe	Feb-15	Repeat
	Jerry	Feb-15	First-timer
	Jenny	Feb-15	First-timer
	Jill	Mar-15	First-timer
	Jenny	Mar-15	Repeat
	Jane	Mar-15	Repeat
	Jess	Mar-15	Repeat
	Jill	Apr-15	Repeat
	Josh	Apr-15	First-timer
	Jess	Apr-15	Repeat

<tbody>
</tbody>

 

[NiMip]

I may have incorrectly assumed the person only appears once per month. If the dataset has multiple logins for a person in a single month, the solution above won't work so well. Let me know if that's the case and I'll do my best to come up with another way.