Difference between two groups of selected text cells RRS feed

  • Question

  • Hello,

    I was wondering how to make a difference between two groups of selected text cells. I have a list of all computers in my company, and I want to make a new list, in which there will be list of computer names reduced for computer names from another list. Do I need to use a specific function or something else to solve this?

    Wednesday, January 23, 2013 8:45 AM


  • You can use formula like VLookup. In Excel's Help you can find some sample.

    If your data is more then one column you can use this function before using Concatenate or & sign to join strings  

    Take a look on 4th VLookup parameter - is very important.

    Also you can use VBA to build Loop checking words in define ranges. But to help you with that you should add link to file sample

    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Wednesday, January 23, 2013 11:21 AM