Hi Mary,
What version do you have of Excel - I can tell you where to look in version 2007...
Wilma

Wilma L. Reeder
Wilma L. Reeder
Serials Manager
Snowden Library
700 College Place
Lycoming College
Williamsport, PA 17701
(570)321-4089 (direct) or
(570)321-4053 (library)
(570)321-4090 FAX
reeder@lycoming.edu

>>> "Williams, Mary Welch" <mwill108@UTMEM.EDU> 3/6/2009 10:21 AM >>>
Colleagues,

A few years ago I ran across a procedure whery by one could compare
lists in Excel.  A formula containing the word "Trim" would help in
identifying duplicates.

I sometimes compare lists using different colored cells, but it requires
reading through the list and the "Trim" procedure generates a note in a
separate column.

This was outlined in appendix C of a book on electronic resources (I
think) and I cannot remember the title.

If someone has that procedure handy or could point me to the book, I
would be most grateful.

Thanks,

Mary

Mary Williams (mwill108@utmem.edu)
Assistant Professor/Serials Librarian
University of Tennessee
Health Science Center
Library and Biocommunications Center
877 Madison Avenue, Room 250
Memphis, TN 38163

Phone: (901) 448-5154
FAX: (901) 448-5402