+ Reply to Thread
Results 1 to 2 of 2

Finding a range of numbers in a column of numbers

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Finding a range of numbers in a column of numbers

    Hey everyone.

    I have a range of numbers (ex. 111111111-555555555) and i have a column of 2000 9 digit numbers in different spreadsheet. Is there away to create a formula that will tell me if any of the numbers in my range are in the 2000 numbers in the column? I hope that made sense.

    Thanks in advance

  2. #2
    Forum Guru
    Join Date
    North America
    MS-Off Ver
    2002/XP and 2007

    Re: Finding a range of numbers in a column of numbers

    That sounds like a COUNTIFS() function: https://support.office.com/en-us/art...c-aa8c2a866842 =COUNTIFS(range of 2000 numbers,">=111111111",range of 2000 numbers,"<=555555555"). If the result is 0, then none of the entries are in that range. If the result is 1 or more, then there are entries in that range.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Replies: 4
    Last Post: 10-19-2017, 08:12 AM
  2. Finding a specific sum from range of numbers
    By Togaman7 in forum Excel General
    Replies: 5
    Last Post: 08-31-2015, 08:39 PM
  3. Finding TWO numbers from a range of numbers to match a target value
    By Eero in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2014, 10:08 AM
  4. Replies: 4
    Last Post: 05-08-2014, 09:43 PM
  5. Finding the sum within a range of numbers
    By johnbeckman in forum Excel General
    Replies: 11
    Last Post: 12-31-2008, 12:41 AM
  6. finding range of numbers in a column
    By langdon37 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-03-2008, 05:29 PM
  7. Replies: 5
    Last Post: 01-19-2006, 07:30 PM

Tags for this Thread


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