Results 1 to 3 of 3

Finding numbers left in list

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-13-2010
    Location
    Warren, Michigan
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    307

    Finding numbers left in list

    Column M represent the numbers, column O is the "constant" list of numbers, and column P is the sort of numbers LEFT in the list:


    M1: 79 O1: 80 P1: 81
    M2: 82 O2: 81 P2: 40
    M3: 34 O3: 34 P3: 45
    M4: 80 O4: 35 P4:
    M5: 46 O5: 40 P5:
    M5: 35 O6: 45 P6:
    O7: 46 P7:
    O8: 79 P8:
    O9: 82 P9:

    In Col P I was working on this coding below, but I'm getting an "#VALUE" message. What am I missing?

    =IF(FIND($M$1:$M$5,O1,1),O1="")
    Last edited by khank; 03-13-2011 at 01:28 PM.

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