+ Reply to Thread
Results 1 to 2 of 2

Add or remove info to lists and highlight differences between two lists

  1. #1
    Forum Contributor
    Join Date
    02-12-2014
    Location
    al ain
    MS-Off Ver
    Excel 2016
    Posts
    149

    Post Add or remove info to lists and highlight differences between two lists

    Hi all,
    Please solve my problem in the given excel file
    1. Sheet1; how to Add "B000" in the List A or "B00" if the digits and 5 in the list
    2. Sheet2; how to remove "B000" or "B00" from the list
    3. Sheet3; how to highlight difference or find out the difference between to lists

    Thanks in advance..
    Attached Files Attached Files

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Add or remove info to lists and highlight differences between two lists

    Welcome to the forum.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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. [SOLVED] Comparing 2 Lists to Identify Differences
    By ORRACLE1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-10-2012, 02:26 PM
  2. Compare two lists and highlight the differences
    By jsmo in forum Excel General
    Replies: 3
    Last Post: 08-28-2012, 10:27 PM
  3. Replies: 5
    Last Post: 05-21-2010, 04:34 PM
  4. Matches and differences between two lists
    By melvin in forum Excel General
    Replies: 3
    Last Post: 09-21-2009, 11:51 AM
  5. Compare two lists and highlight differences.
    By delgadotb in forum Excel General
    Replies: 1
    Last Post: 03-30-2009, 03:24 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