Oct 12 2017 10:44 PM
Oct 12 2017 10:44 PM
Hi Guys,
I am need some help with excel. every month I have to generate a list of data and compare them againt the master files and get the removed and added list. Please find attached worksheet, for exaple I have master files with 4 coulms Host name, Domain , IP, OS then the generated report has Host name, Domain, IP, OS and last reported time stamp.
What I need is find out is check all the hostname and IP from generated report and check if same exist in original report , if they exist get the time stamp.
Would appriciate if some one could help. Thank you in advance.