+ Reply to Thread
Results 1 to 2 of 2

Compare Columns and Find Difference

  1. #1
    Registered User
    Join Date
    02-06-2008
    Posts
    20

    Compare Columns and Find Difference

    Hi I am fairly new to excel and trying to figure out something and any help would be appreciated. I scan out parts to techs everyday and then scan them back in the next and need to figure out what hasn't came back. Each tech has his own workpage in the workbook. Column A1:A150 would be scanned out parts and B1:B150 would be scanned in parts. I need to compare Column B to Column A and remove the number from A if its on B, or something to that effect so we can quickly see what parts were not returned.
    I will attach an example of one of the sheets from the book. Thank you in advance for your help. I'm sorry but it won't let me upload the page because its a .rar file and I don't have winzip on the company computer. Still any advise would be appreciated.

  2. #2
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,163
    This code compares A to B and fills column C adjacent cell either Red or Green.

    Please Login or Register  to view this content.
    Regards

    Rick
    Win10, Office 365

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1