LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 67
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
search/delete duplicate entries in excel '02? madpeyjag Excel Worksheet Functions 3 October 27th 06 01:52 AM
Printing text in a repeated cell/row that is longer than repeated Valerie Dyet Excel Discussion (Misc queries) 1 February 13th 06 03:27 AM
Identify repeated cell entries in multiple sheet workbook as you . Trigger Excel Discussion (Misc queries) 0 August 17th 05 01:57 AM
How do I search a mailing list spreadsheet to remove entries alre. RagDyer Excel Discussion (Misc queries) 1 March 28th 05 09:29 PM
Filtering a column to exclude any repeated entries. bay Excel Discussion (Misc queries) 2 January 27th 05 10:13 AM


All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"