Posts by ryaneschroeder

    Hello All,


    Im looking to count the total number of days a person has entered a facility. In this example you will see that each individual has entered more than once each day. The end result should be as follows. I've been working on this for awhile and just cant seem to get this no matter the type of formula or combination of formulas I use.


    Sample Table


    [TABLE="width: 275"]

    [tr]


    [td]

    Transaction

    [/td]


    [td]

    Date

    [/td]


    [td]

    Person

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    10/5/16

    [/td]


    [td]

    DOE , JANE

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    10/5/16

    [/td]


    [td]

    DOE , JANE

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    10/4/16

    [/td]


    [td]

    DOE , JANE

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    10/4/16

    [/td]


    [td]

    DOE , JANE

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    10/4/16

    [/td]


    [td]

    DOE , JANE

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    11/21/16

    [/td]


    [td]

    SMITH , JOHN

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    11/7/16

    [/td]


    [td]

    SMITH , JOHN

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    11/7/16

    [/td]


    [td]

    SMITH , JOHN

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    10/17/16

    [/td]


    [td]

    SMITH , JOHN

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    10/17/16

    [/td]


    [td]

    SMITH , JOHN

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    10/12/16

    [/td]


    [td]

    SMITH , JOHN

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    11/28/16

    [/td]


    [td]

    WILLIAMS , JAMES

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    11/28/16

    [/td]


    [td]

    WILLIAMS , JAMES

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    11/28/16

    [/td]


    [td]

    WILLIAMS , JAMES

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    11/18/16

    [/td]


    [td]

    WILLIAMS , JAMES

    [/td]


    [/tr]


    [tr]


    [td]

    Entered

    [/td]


    [td]

    11/18/16

    [/td]


    [td]

    WILLIAMS , JAMES

    [/td]


    [/tr]


    [/TABLE]


    Jane Doe - 2
    John Smith - 4
    James Williams - 2