I have been adding data to a very large spreadsheet, but i am now receiving
data with the same id number. Is there anyway i can have excel telling me
this id number is already been added without going through the whole document
or going through the sort icon . I know it tells you this when you working on
a spreadsheet when opened, but when you close and reopen this function is no
longer active.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200712/1

"chedd via OfficeKB.com" <u18187@uwe wrote in message
news:7c3a8c528f158@uwe...
I have been adding data to a very large spreadsheet, but i am now receiving
data with the same id number. Is there anyway i can have excel telling me
this id number is already been added without going through the whole
document
or going through the sort icon . I know it tells you this when you working
on
a spreadsheet when opened, but when you close and reopen this function is
no
longer active.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200712/1


Take a look here for information about duplicates:
http://www.cpearson.com/excel/Duplicates.aspx

Hi!
I have found an add-in for Excel that can look for duplicate cells (values)
in a table. Try it, maybe it fits your needs:
http://www.office-excel.com/excel-ad...ta-finder.html

Best regards,
Eugene
"chedd via OfficeKB.com" <u18187@uwe wrote in message
news:7c3a8c528f158@uwe...
I have been adding data to a very large spreadsheet, but i am now receiving
data with the same id number. Is there anyway i can have excel telling me
this id number is already been added without going through the whole
document
or going through the sort icon . I know it tells you this when you working
on
a spreadsheet when opened, but when you close and reopen this function is
no
longer active.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200712/1