Hello,
I have an excel spreadsheet with chart number and data, many chartnumbers are there multiple times (which is correct). 36K rows. I want to remove patients who aren't in another list (a spreadsheet of those patients included in my study, a list of some 400 patients, one record for each person).
How do I remove the rows from the first file, which aren't in the second list. Or vice versa, select those rows that are in the second list.
Thanks,
Neil
Configuration: Windows XP Internet Explorer 7.0
Hello
|
Basic excel formulas list Delete duplicate rows in excel if formula Dos script to remove files based on list Excel if a value equal add Excel create list from dynamically updated data Excel if a cell is this value fill this value Excel if formula time and text Excel if information empty hide cell Excel if n/a entered in one cell - other specific cells to contain the same Excel if statements return current field if earlier date Excel if y then if n then Excel make list of all cells containing value Excel, if function return a colour How to compare two excel spreadsheets and remove rows from one How to remove avg 8 if i cant find it in my uninstall programs Make a cell turn a color excel if statement Microsoft excel formulas list Remove program from program list