lindajones
New Member
- Joined
- Apr 8, 2003
- Messages
- 4
*What I am starting with: 1 spreadsheet containing 11,000 rows of account data and a 2nd spreadsheet containing 350 rows of account data (both sheets have a column for 'Account#' to identify each entry.
*What I would like to accomplish: I need to compare the account number column in the small sheet with the account number column in the large sheet----if duplicate values exist, I would like to somehow flag the duplicates in the large sheet so that I can delete the duplicate rows entirely.
[i.e. I am trying to filter the entries from the small sheet OUT of the large sheet so that I can use the remaining rows of good data.]
Any ideas, besides manually searching and deleting 350 times?
Thanks.
*What I would like to accomplish: I need to compare the account number column in the small sheet with the account number column in the large sheet----if duplicate values exist, I would like to somehow flag the duplicates in the large sheet so that I can delete the duplicate rows entirely.
[i.e. I am trying to filter the entries from the small sheet OUT of the large sheet so that I can use the remaining rows of good data.]
Any ideas, besides manually searching and deleting 350 times?
Thanks.