+ Reply to Thread
Results 1 to 6 of 6

Combining if(isnumber(search with Frequency

  1. #1
    Registered User
    Join Date
    10-15-2008
    Location
    Gloucester
    Posts
    7

    Combining if(isnumber(search with Frequency

    I am trying to combine a If(is(numbersearch combination with a Frequency formula , i am not using sumproduct as want to return a complete total if criteria is blank.

    Where i am trying to get to
    When a certain validation is entered it returns the number of individual number combinations in a column ignoring duplicates (columns are number only not text)

    Hope you can Help

    Very striped down Example attached
    Attached Files Attached Files
    Last edited by Marshall101; 10-15-2008 at 10:17 AM. Reason: Solved

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

    Combining if(isnumber(search with Frequency

    I think you'll need to post an example of some data and what you want the formula to return.
    Or, perhaps better, zip an Excel workbook with the example.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    10-15-2008
    Location
    Gloucester
    Posts
    7
    Thanks example added

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

    Combining if(isnumber(search with Frequency

    Using your posted workbook....

    I assigned a range name to the list on Sheet1 so the DV list on Sheet2
    could reference the list.
    Names in workbook: LU_NameList
    Refers to: =Sheet1!$B$4:$B$6

    On Sheet2, this regular formula returns the number of unique accounts
    that the person in D5 has...
    Please Login or Register  to view this content.
    Using your sample data, the formula returns 3 for Paul.

    I attached the revised workbook to this post.

    Is that something you can work with?
    Attached Files Attached Files
    Last edited by Ron Coderre; 10-15-2008 at 10:23 AM.

  5. #5
    Registered User
    Join Date
    10-15-2008
    Location
    Gloucester
    Posts
    7

    Thanks

    Thats great , thanks for you help has been buggin me for days

    That goes to all replies
    Last edited by Marshall101; 10-15-2008 at 10:21 AM.

  6. #6
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    There's probably a simpler formula, but this works for me:
    Please Login or Register  to view this content.
    Notice that the first part of Sumproduct has one more row than necessary, because Frequency contains one more element than the references would lead you to believe.

    Edit: Looks like I'm a little late.

+ 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. Histogram + Frequency + Statistical Analysis
    By NoPuck4You in forum Excel General
    Replies: 4
    Last Post: 04-22-2015, 11:21 AM
  2. Using a threshold to detect frequency of oscillations
    By abcd3fg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-14-2008, 01:31 PM
  3. Transposing Frequency data
    By jonshrives in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-08-2007, 01:19 PM
  4. generate random numbers from a frequency list
    By adeina in forum Excel General
    Replies: 11
    Last Post: 06-21-2007, 11:34 AM
  5. Frequency of two criteria
    By Smint in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2007, 12:22 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