+ Reply to Thread
Results 1 to 7 of 7

Unique number of attendants

  1. #1
    Registered User
    Join Date
    12-20-2017
    Location
    Turku, Finland
    MS-Off Ver
    Office 365 Home / Office 2013
    Posts
    11

    Unique number of attendants

    Hi,
    I'm registering attendants for an event with several sessions. How do I check number of unique visitors. I.e a visitor that attends several session will be counted only once.

    Attaching a sample file, cell E4 is what I want to calculate. Now it is a mockup.

    /Bjoern Bergvall
    Attached Files Attached Files
    Last edited by Bion; 01-03-2018 at 05:46 AM. Reason: Updated to correct attachment

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,404

    Re: Unique number of attendants

    Try this:

    =SUMPRODUCT(1/COUNTIF(A2:A10,A2:A10))
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    12-20-2017
    Location
    Turku, Finland
    MS-Off Ver
    Office 365 Home / Office 2013
    Posts
    11

    Re: Unique number of attendants

    Thanks, that was quick!
    Could you please send it in an Excel file? I'm working in a swedish version of Excel and don't find the functions, in an Excel file they will interpreted to swedish.

    /Bjoern

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,404

    Re: Unique number of attendants

    All solutions here will be offered in English, so please bookmark this page for future reference: http://easy-excel.com/excel-in-other...as-in-swedish/

    Please mark the thread as solved. Thanks.
    Last edited by AliGW; 01-03-2018 at 05:56 AM.

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Unique number of attendants

    maybe this: =PRODUKTSUMMA(1/ANTAL.OM(A2:A10;A2:A10))

  6. #6
    Registered User
    Join Date
    12-20-2017
    Location
    Turku, Finland
    MS-Off Ver
    Office 365 Home / Office 2013
    Posts
    11

    Re: Unique number of attendants

    Thanks for the solution, and URL.

    /Bjoern

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,404

    Re: Unique number of attendants

    You're welcome!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. [SOLVED] If or Match 1 unique number to return another number 2 different problems
    By justinwb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2017, 09:18 AM
  2. How do I create a reverse number list starting with ZERO as the first unique number?
    By AlainDavidBoucher in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-15-2017, 04:19 PM
  3. VBA: Multiple text and number columns. Find list and number of unique words
    By first_jaguar in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 07-14-2017, 09:58 PM
  4. [SOLVED] Count the number of occurrence upto now and assign a unique sequence number
    By chathuranga in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-22-2016, 07:25 AM
  5. [SOLVED] Count the number of Unique Items in a Column for each Unique Item in another Column
    By HangMan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-27-2015, 01:18 PM
  6. [SOLVED] Applying unique ID's to rows but keep same unique ID number for duplicates
    By sirjames2829 in forum Excel General
    Replies: 2
    Last Post: 12-11-2012, 06:14 PM
  7. Overwrite the advanced filtered data serial number column with unique number
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-15-2012, 12:38 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