I have a table that had a couple thousand rows in it. The first column has a bunch of number IDs in it. A specific ID may be in the column multiple times. I have a separate column outside the table that has a list of unique IDs. What I would like to do is create a new table where the first column only contains IDs from the separate list of IDs. For instance:
my sample table: the column of unique IDs:
ID value | unique ids
1---44--|---1
2---41--|---2
1---39--|---6
3---26
6---17
12--15
12--14
2---14
2---12
new table I want to create based on the above table and ID list:
ID value
1---44
2---41
1---39
6---17
2---14
2---12
In the above example, I specify the IDs 1, 2, and 6 so the resulting table I want to create can only have IDs 1, 2, 6 in the first column. The resulting table is a subset of the original table. Can I write a formula or something that does this without writing a macro? I am sure I could write a macro to do this but would like to know if it can be done without a macro. I have turned the data into a table and I can click on the column and uncheck all the values I do not want and that works if you just have a couple of ones you want to select or deselect but I have ~200 IDs I need to select so I would like it to be automated. Like take all the values in Column O and cross reference then with Column N and all the rows that match in the table, copy them to some box.
Bookmarks