+ Reply to Thread
Results 1 to 4 of 4

Find how many times a cell value exists in another range

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    England
    MS-Off Ver
    2007
    Posts
    186

    Find how many times a cell value exists in another range

    Hi,

    On a worksheet I have used this formula to state true or false if the value in a cell exists or not in a range on another worksheet.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Rather than just stating if the value exists or not in the other range, I want to state the number of times it exists. Stating zero if it's not there at all.

    Please could someone show me how best to do this?

    Small example attached.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Find how many times a cell value exists in another range

    using your posted workbook,
    this regular formula, copied down, returns the count of Col_A values on the OtherSheet tab
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Contributor
    Join Date
    03-14-2013
    Location
    England
    MS-Off Ver
    2007
    Posts
    186

    Re: Find how many times a cell value exists in another range

    Yes thanks, can't believe I didn't think of that.

    Cheers for the help

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Find how many times a cell value exists in another range

    Glad you got something you can use!

    If that resolves your issue, please take a moment to mark this thread as SOLVED (from the Thread Tools menu)

+ 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. Range.Find function fails to find a match but For loop confirms that match exists
    By 6StringJazzer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-08-2013, 03:35 PM
  2. Time query to find number of times in a certain range
    By aloha31 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-13-2013, 04:46 PM
  3. Replies: 9
    Last Post: 07-03-2013, 07:39 AM
  4. [SOLVED] check if number in once cell exists in a range of cells and if yes, format another cell
    By beaujolais44 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-16-2013, 07:23 AM
  5. find how many times a value is in range B3:D12
    By Ironchef in forum Excel General
    Replies: 8
    Last Post: 03-10-2008, 12:41 PM

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