+ Reply to Thread
Results 1 to 5 of 5

Count cells with multiple entries

  1. 03-16-2023, 11:22 AM #1
    RoscoW88
    RoscoW88 is offline
    Forum Contributor
    Join Date
    06-04-2013
    Location
    Suffolk, England
    MS-Off Ver
    Office 365
    Posts
    153

    Count cells with multiple entries

    Good Afternoon,

    I am looking for some assistance on an problem i currently have....

    I have a number of sites and a calendar that i need to calculate visits for over the month.

    There is a possibility that multiple sites are visited in a day.

    Is there a way in which you could count a cell entry such as 'UK/US' as UK=0.5 US=0.5?

    I have attached a sample sheet for your perusal.

    Many Thanks
    Ross
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-16-2023, 12:25 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,995

    Re: Count cells with multiple entries

    Try this, for the specific example shown:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 03-16-2023, 12:37 PM #3
    raptor_k7
    raptor_k7 is offline
    Registered User
    Join Date
    02-03-2012
    Location
    Bangalore, INDIA
    MS-Off Ver
    O365
    Posts
    54

    Re: Count cells with multiple entries

    Please find attached file, Hope this helps!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 03-16-2023, 01:46 PM #4
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Count cells with multiple entries

    with Power Query ( Get&Transform )

    01-Jan 02-Jan 03-Jan 04-Jan 05-Jan 06-Jan 07-Jan DE ES FR GB PT RO UK US
    UK/FR UK/US US/GB ES DE/RO PT FR
    0.5
    1
    1.5
    0.5
    1
    0.5
    1
    1


    with limited countries per day to eg. AB/CD but not AB/CD/EF or more, description should be more precise
    Attached Files Attached Files
    Last edited by sandy666; 03-16-2023 at 02:15 PM.
    Reply With QuoteRegister To Reply
  5. 03-16-2023, 02:35 PM #5
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Count cells with multiple entries

    Power Query for multiple countries

    01-Jan 02-Jan 03-Jan 04-Jan 05-Jan 06-Jan 07-Jan 08-Jan CS DE ES FR GB IT NO PT RO UK US
    UK/FR UK/US US/GB ES DE/RO PT FR IT/CS/ES/NO
    0.5
    0.5
    1.5
    1.5
    0.5
    0.5
    0.5
    1
    0.5
    1
    1
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count Multiple entries as one
    By msgjazz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-19-2016, 07:26 PM
  2. Count entries per row across multiple sheets with fulfill multiple criteria
    By Lea82 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-11-2013, 02:39 AM
  3. Count multiple entries once
    By keswickjeff in forum Excel General
    Replies: 2
    Last Post: 08-10-2011, 03:47 PM
  4. Count name entries in multiple books
    By dr mint in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2010, 03:15 AM
  5. Count Multiple Entries, Return Multiple Rows, Based On 3 Criteria
    By gtj_global in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2008, 06:40 PM
  6. =CountIf to Count Multiple Entries
    By scotfitz in forum Excel General
    Replies: 1
    Last Post: 07-21-2008, 08:28 AM
  7. Count number of cells with different entries
    By ebneterc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2007, 06:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1