Hi - I have used the following formula to find duplicates between sheets:
in the next blank column in sheet 1 I enter the following =if(iserror(match(a2,Sheet2!$a$2:$a$1449,0)),"",a2)
The numbers in sheet 1 columnA represent isbn numerical listings of books. There may be 4 or 5 copies of the same numerical listing.
In sheet 2 are all the isbn numerical listings that need to be removed from sheet 1. There are only single instances of the numerical listings to be removed.
When I use the above formula the values returned are equal the number of copies in sheet1, even if I only need 1 copy removed.
How do I identify only those items in sheet 2 that need to be removed without all the numbers in sheet 1 being identified for removal. Here's a visual representation:

sheet1
ColumnA
1a 1234
2a 1234
3a 2324
4a 2325
5a 2326
ColumnB with formula result
1a 1234
2a 1234
3a 2324
4a 2325
5a 2326

Sheet2
ColumnA
1a 1234
2a 2324
3a 2325
4a 2326


In the illustration above sheet2 columnA shows only 1 instance of the numerical value"1234", but in the result on sheet1 columnB it produces 2 instances of the numerical value "1234". How can I modify the formula or create a formula that only provides the duplicate rows in sheet2 to the results in sheet1?

Hope I have been clear
Thanks
Bookends