excel compare two columns and highlight missing

excel compare two columns and highlight missing


I wanted a Excel expert, who can create a script in excel for compare two columns and highlight a missing data. The Column1 will have a full list of IP´s and Column2 will have a exported running servers IP´s with missing (dropped) IP´s.

For example:

LIST1: (all IP´s)
.. more that 500 rows..

.. more than 500 rows

Script will highlight a missing IP´s, or show a dropped IP´s in the another column

Missing IP´s:

Thanks for you bids


Excel experts
Must be capable with Excel 2010+

Skills Required



i have experience about excel.i also know programming.please consider me.thank you

i will do it for you to get my first seo clerks good review. i can do it for you before payment and i will send to you photo of the result.
after payment directly you will get your script

Created 4 years ago in Programming

Other jobs by michalpikulak