+ Reply to Thread
Results 1 to 4 of 4

Need assistance with searching cells

  1. #1
    Forum Contributor
    Join Date
    05-17-2012
    Location
    Silver Spring
    MS-Off Ver
    Excel 2016
    Posts
    212

    Need assistance with searching cells

    Good Afternoon,
    What I need help with is kind confusing.
    Say in Sheet 1, I have a list of computers in Column A. (Computer 1, Computer 2, Computer 3, Computer 4, Computer 5)(An inventory basically)

    Now in Sheet 2, I have the users in Column A and Column B through F shows what computers they have logged onto.
    The sheet 1 is a common list of computers but there are users that can use computers that are not on Sheet 1. My goal is to track those unknown systems.

    Therefore, if say User1, is using Computer 1, Computer 2, Computer 8, Computer 9.

    I need a formula to be able to look at Column 1 at User1, look at the computers in columns B through F. Verify which ones are NOT on Sheet 1 (inventory), (In our example Computer 8, Computer 9)
    Then give me an output lets say on Sheet 3 saying:

    Col A1: User 1
    Col B1: Computer 8
    Col C1: Computer 9

    Then for the next user that shows up with different computers would go to the next row
    Col A1: User 2
    so forth?

    I've attached an example file.
    Thank you very much in advance.
    Attached Files Attached Files
    Last edited by AceForSale; 05-15-2015 at 12:39 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Need assistance with searching cells

    Do you really need a listing on Sheet 3?

    I ask because it is much easier to simply use conditional formatting to highlight the unlisted computers. See attached file...

    Note I created a dynamic named range for the list of computers. It will automatically adjust to adding/removing computer list on Sheet 1 as long as they are contiguous from A1 down.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-17-2012
    Location
    Silver Spring
    MS-Off Ver
    Excel 2016
    Posts
    212

    Re: Need assistance with searching cells

    Unfortunately yes because the end game is I'll be using sheet 3 with the results to report from.
    I'm familiar with how to do it from Conditional formatting already.

    I just need a way to search Col B-F for whats on another list and if it cant find it, it lists it
    Dave

  4. #4
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Need assistance with searching cells

    See attached file...

    May not work in 2003.
    Attached Files Attached Files

+ 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. Assistance with linked cells: bold formatting & filled cells
    By chiasmus811 in forum Excel General
    Replies: 1
    Last Post: 06-25-2011, 03:24 AM
  2. [SOLVED] need assistance with merging cells
    By Gord Dibben in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-06-2005, 09:05 AM
  3. need assistance with merging cells
    By Helen in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  4. need assistance with merging cells
    By Helen in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. [SOLVED] need assistance with merging cells
    By Helen in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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