Re: Excel function Paoshan Yue 09 Mar 2009 17:45 UTC
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.