+ Reply to Thread
Results 1 to 4 of 4

Find and Count Occurrences of random cell values

  1. #1
    Registered User
    Join Date
    04-05-2019
    Location
    Zurich, Switzerland
    MS-Off Ver
    MS Office 2019
    Posts
    6

    Find and Count Occurrences of random cell values

    Hello,

    I'm new to VBA and I encountered a problem. I got Sheet with different tasks i need to do. These can vary over the time so these tasks aren't permanent. (That's why i didn't use the countif command)
    Now i want to list all the Tasks that are in the list again somewhere else in the Sheet and next to the created list the number of times this task was done. I've created a Samplesheet to clear things up if it wasn't clear enough already.

    I've searched through the Internet, but couldn't find anything that fits my situation.

    I'm thankful for any piece of advice

    Joel
    Attached Files Attached Files
    Last edited by joelmoor; 04-11-2019 at 07:47 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: Find and Count Occurrences of random cell values

    I don't think you searched hard enough: https://www.excelforum.com/excel-pro...materials.html

  3. #3
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Find and Count Occurrences of random cell values

    Try this:-
    Please Login or Register  to view this content.
    Regards Mick

  4. #4
    Registered User
    Join Date
    04-05-2019
    Location
    Zurich, Switzerland
    MS-Off Ver
    MS Office 2019
    Posts
    6

    Re: Find and Count Occurrences of random cell values

    Exactly what i needed, thank you very much!

+ 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. Count occurrences that contain one or more named range values
    By RelativeRisk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-25-2018, 03:22 PM
  2. Trying to count the number of occurrences of duplicate values
    By rahworks in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-11-2014, 02:55 PM
  3. Using .Find() Function in Excel to count number of occurrences
    By Saarang84 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-19-2013, 10:40 AM
  4. Replies: 3
    Last Post: 10-23-2013, 08:42 AM
  5. [SOLVED] In a single cell, count any occurrences from a list of values
    By daedelous00 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-05-2013, 03:30 PM
  6. find over certain value, count occurrences and max
    By chi11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2012, 06:25 PM
  7. Count occurrences of values in a column??!!
    By me123 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-10-2006, 03:40 PM

Tags for this Thread

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