I'm guessing this is pretty simple, but I don't know what terms to search for.
I have a worksheet with a visitor log:
Name Login Logout
1 Mike 12:34 12:34
2 Bob 12:34 12:34
3 Sue 12:34 12:34
4 Fred 12:34 12:34
5 Mike 12:34 12:34
6 Alice 12:34 12:34
7 Fred 12:34 12:34
8 Brian 12:34 12:34
9 Sean 12:34 12:34
10 Bill 12:34 12:34
11 Mike 12:34 12:34
12 Mary 12:34 12:34
13 Tom 12:34 12:34
14 Abby 12:34 12:34
15 Fred 12:34 12:34
16 Mike 12:34 12:34
17 Sue 12:34
18 Jeff 12:34 12:34
19
20
I need to generate a table with the number of visits for each visitor, like this:
Name Visits
Mike 4
Bob 1
Sue 2
Fred 3
Alice 1
Brian 1
Sean 1
Bill 1
Mary 1
Tom 1
Abby 1
Jeff 1
I assume this would be some kind of pivot table, but I can't figure out how to create it.
Bookmarks