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.
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
Thanks for you bids
Must be capable with Excel 2010+