Seocheckout

excel compare two columns and highlight missing

excel compare two columns and highlight missing

Hi.

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)
36.125.2.1
98.102.1.3
74.54.3.11
.. more that 500 rows..

LIST2:
74.54.3.11
.. more than 500 rows

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

Missing IP´s:

36.125.2.1
98.102.1.3
43.44.122.3
etc...

Thanks for you bids


Requirements

Excel experts
Must be capable with Excel 2010+


Skills Required

Excel

Bids

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

i will do it for you to get my first seocheckout 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

Bid On Listing Created 8 years ago in Programming

Other jobs by michalpikulak