Results 1 to 8 of 8

Formula/Array to return results in a certain range

Threaded View

  1. #1
    Registered User
    Join Date
    01-29-2011
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    4

    Formula/Array to return results in a certain range

    Hello all. I'm new here and have been trying to figure out the best way to write this formula.
    It's been giving me a headache trying to figure this out.
    The rundown:
    I have a simple sheet which shows 3 columns: "Date", "Contract#", & # of Contracts"
    (Please click link to see simple spreadsheet showing example)
    http://img10.imageshack.us/img10/49/excelsshot.jpg

    The contracts all contain 5 or 6 #'s which contain numbers from 1-30. Each # in the contract represents different stages in the billing process.

    I need a formula/array that shows which #'s are not appearing within the range 1-30 for the entire group of B2:B9 (not individually, but for the entire range).

    So, please see below list in BOLD RED in the range B2:B9... I've highlighted numbers below are not appearing:
    1-2-3-4-5-6-7-8-9-10-11-12-13-14-15-16-17-18-19-20-21-22-23-24-25-26-27-28-29-30

    I need a formula which will shows the #s in BOLD RED since they are not appearing in the range 1-30 in the cells B2:B9

    I hope I didn't make the questions confusing.

    Thank you in advance, I really appreciate the help!
    Last edited by B_Riz; 01-30-2011 at 02:14 PM. Reason: Moderator requested to have title change

Thread Information

Users Browsing this Thread

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

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