How sort and match multiple Excel rows to one row
Posted on 2007-12-01
Ok Excel Guru's
I have 4 columns of data. Each column is a list (audit) of the computer names on my network.
The rows are from AD, SAV, WSUS, and a Network Security Scan Tool.
Some computer names are on all the columns. Some are only in one or two of the columns. Each column of data has a different number of entires. Some over a hundred entires difference. So sorting is out of the question. Is there a way to sort all four rows to the first (largest) row. Have all matching entires in the columns sorted next to its match in the first column. Where there is no name match, the cell would be colored red to show where there is a mis-match.
Now, if there is an entry in one of the other columns. Take for instance the Network scan picks up a Computer name but it isnt in AD. A row in the AD coloum would turn red. And visa vera. I walked into a bad situation and I need a way to organize this data.
If it can not be done in Excel. Can someone please let me know any other formats or programs that I can use to format this data this way.