Need to filter row data by comparison of two columns
Posted on 2011-05-06
I hope I can explain this well enough. I have a spreadsheet that shows a list of employees and their information (about 2000 rows), one of the columns (B) is their ID, I then have another column (column A) that I imported into the spreadsheet so it is not in the same order as column B; however, it does correspond to column B (about 128 rows), I am trying to setup excel to only show me the 128 rows (not all 2000), but I want to see the corresponding employee information from columns C-H but filtered by the employee ID's from column A? Does this make sense?
So, Column A has ID's and Column B has ID's, the additional columns C-H have information about the employee's as related to the ID from column B, but I want to filter column B to match the same ID from column A so that I can ultimately see the employee information about all the employees who's ID's are listed in column A.