Hey everyone,

I have a huge table, columns A-Z and 933 rows (row 1 being the header row).

I trimmed this table down to 366 rows, but somehow, the data in the columns got all wacko, and I need to revert back to the 366 row trimmed table.

My idea is this:
Match the values in column H (i.e. 1100374 - Unique Name 43) from the trimmed table to the values in common H of the complete table. If there is a match, keep that row in the complete table. If there is no match, delete that row from the complete table. Any ideas how to do this?

Thanks!