+ Reply to Thread
Results 1 to 2 of 2

How to get visitor visits count from visitor log

  1. #1
    Registered User
    Join Date
    12-04-2020
    Location
    Minnesota
    MS-Off Ver
    o365
    Posts
    1

    Question How to get visitor visits count from visitor log

    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.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,740

    Re: How to get visitor visits count from visitor log

    does the login/logout time matter? otherwise you are just counting the names
    pivot table
    enter Name into ROW and Name into Values and it should count the number of names in the list

    sample attached
    if not the case, then perhaps ad da sample and reasons for the results expected
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with workbook visitor counter
    By dori2o in forum Excel General
    Replies: 1
    Last Post: 05-03-2018, 11:05 AM
  2. [SOLVED] Visitor log macro
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-31-2016, 05:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1