+ Reply to Thread
Results 1 to 5 of 5

Numbers Exist/Not exist in a range

  1. 12-04-2008, 02:50 PM #1
    ElmerS
    ElmerS is offline
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Numbers Exist/Not exist in a range

    Hi,
    My question/request is explained in the attached file,
    Thanks,
    Elm
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-04-2008, 03:12 PM #2
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Numbers Exist/Not exist in a range

    I used formulas to list the missing and listed items in the edited
    version of the workbook you posted.

    Is that something you can work with?
    Attached Files Attached Files
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
  3. 12-04-2008, 03:44 PM #3
    ElmerS
    ElmerS is offline
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412
    Yes, this is what I had in mind.

    I allow myself to ask an additional question:
    How can I declare "Conditional formatting" as shown in Sheet1 ?

    Thank you.
    Attached Files Attached Files
    Last edited by ElmerS; 12-04-2008 at 03:55 PM.
    Reply With QuoteRegister To Reply
  4. 12-04-2008, 04:19 PM #4
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Conditional formatting

    Using your posted workbook...

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 12-04-2008, 04:34 PM #5
    ElmerS
    ElmerS is offline
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412
    GREAT...!

    Until next time,

    Thanks a lot.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1