Hi Mary,

If you discover the source for this, I would appreciate it if you could
post the information to the list.

Thank you,

Marsha Bennett
Serials Librarian
Boston Public Library
Serials Department
700 Boylston Street
Boston, MA 02116
U.S.A.
================
Tel:  617-536-5400, x2310
Fax: 617-424-1040
mkbennett@bpl.org

-----Original Message-----
From: SERIALST: Serials in Libraries Discussion Forum
[mailto:SERIALST@list.uvm.edu] On Behalf Of Devereaux, MaryJo
Sent: Monday, March 09, 2009 8:06 AM
To: SERIALST@LIST.UVM.EDU
Subject: Re: [SERIALST] Excel function

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.