Email list hosting service & mailing list manager


Re: Excel function Williams, Mary Welch 09 Mar 2009 19:28 UTC

That's it!!

Now that you quote authors I recognize it.

Thanks so much.  I knew I could count on our collective wisdom.

Mary

-----Original Message-----
From: SERIALST: Serials in Libraries Discussion Forum
[mailto:SERIALST@list.uvm.edu] On Behalf Of Paoshan Yue
Sent: Monday, March 09, 2009 12:46 PM
To: SERIALST@LIST.UVM.EDU
Subject: Re: [SERIALST] Excel function

Hi Mary,

It's in this book (Appendix C):

Developing and managing electronic journal collections : a how-to-do-it
manual for librarians / Donnelyn Curtis, Virginia M. Scheschy, Adolfo R.
Tarango
Publisher New York : Neal-Schuman Publishers, c2000
(http://www.worldcat.org/oclc/44426774)

Enjoy!

Paoshan
--------
Paoshan Yue
Director of Technical Services
Mathewson-IGT Knowledge Center / MS 322
University of Nevada
1664 N. Virginia Street
Reno, NV 89557-0044
775-682-5599
yue@unr.edu

________________________________________
From: SERIALST: Serials in Libraries Discussion Forum
[SERIALST@list.uvm.edu] On Behalf Of Bennett, Marsha K.
[mkbennett@BPL.ORG]
Sent: Monday, March 09, 2009 6:28 AM
To: SERIALST@LIST.UVM.EDU
Subject: Re: [SERIALST] Excel function

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.