Hi Mary, If you get the answer to this question, would you please let me know.  Thanks!

Mary Jo Devereaux, M.L.S.
Physician's Library/CME Services
CMC Hospital
1800 Mulberry Street
Scranton  PA  18510
v. 570-969-8197
f. 570-969-8902

-----Original Message-----
From: SERIALST: Serials in Libraries Discussion Forum
[mailto:SERIALST@list.uvm.edu]On Behalf Of Williams, Mary Welch
Sent: Friday, March 06, 2009 10:21 AM
To: SERIALST@LIST.UVM.EDU
Subject: [SERIALST] Excel function

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

DISCLAIMER: The information in this message is confidential and may be legally privileged.  It is intended solely for the addressee. Access to this message by anyone else is unauthorized.  If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.  Please immediately contact the sender if you have received this message in error. Thank you.