Email list hosting service & mailing list manager

(Previous discussion continued)
Re: Excel function WILMA REEDER (09 Mar 2009 16:13 UTC)

Re: Excel function WILMA REEDER 09 Mar 2009 16:13 UTC

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

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

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

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.



Mary Williams (
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