How can I search for entries that are repeated in the workbook?
I have approximately 2500 properties (address number, street name and tax
bill number) and 25 sheets (each representing a different property
developer). I need to determine if the same property has been allocated to
more than one developer, that is whether an entry is repeated on more than
one sheet or even the same sheet.
I would also like to calculate exactly how many entries are in the entire
workbook.
Thanks,
Ivan
|