Hello. I hope someone can help me. My team and I collect data on large numbers of Pcs in my corporation to insure they are up to date with all the microsoft security patches. We collect this data in the morning and afternoon. We put the mornings list of PC names in column A. The afternoons list goes in column B. I want to use columns C&D to show the sort. Column C should show what was on A in the Morning and is no longer on B for the Afternoon. (those that fell off(got the patch)) and Column D should show what is on B in the Afternoon and was not on A in the Morning. (new machines)
I have not been able to work out a solution. ANY help woud be GREATLY appreciated and I thank you in advance for everyone's time and trouble [/img]
I have not been able to work out a solution. ANY help woud be GREATLY appreciated and I thank you in advance for everyone's time and trouble [/img]