[ILL-L] [ARIE-L] Comparing lists -- spreadsheet offer

[Hocking, Kim]

Hi, 

Can you send me the Excel 2007 version? Thanks!

*******************************
Kimberly A. Hocking, MLS
Public Services Librarian
khocking at peace.edu
919-508-2304 (voice)
919-508-2769 (fax)
*******************************

-----Original Message-----
From: ILL_PSC ILL_PSC [mailto:ILL_PSC at mail.wvu.edu] 
Sent: Monday, April 28, 2008 7:47 PM
To: arie-l at u.washington.edu; ill-l at webjunction.org
Subject: [ILL-L] [ARIE-L] Comparing lists -- spreadsheet offer

Hello!

For years, I've been manually comparing Ariel lists and LVIS lists to
create the , but at last I've found a way to use EXCEL to do it
automatically.

It can be adapted to compare any two lists: Old Ariel libraries vs. New
Ariel libraries; free libraries vs. Odyssey libraries, etc. 

The instructions came from:
http://exceltips.vitalnews.com/Pages/T002251_Comparing_Lists_for_Duplica
tes.html   I use Excel 2007, so I had to do some finagling to figure it
out, but it works.

If you would like a copy of the Compare Lists workbook, I'd be happy to
send it to you as an attachment. It consists of three worksheets: List1,
List2, and How To Instructions.

Please reply off list to ILL_PSC at mail.wvu.edu and tell me whether you
want the EXCEL 2007 or the EXCEL 97-2003 version.

Linda

Linda Celet Bane
Interlibrary Loan (PWS/PWSA)
Mary F. Shipper Library/LRC
Potomac State College of WVU
Keyser, WV  26726-2697
phone: (304)788-6903
fax: (304)788-6946
Ariel: 157.182.165.30, PSC_Ariel at mail.wvu.edu
Odyssey: 157.182.165.30/ILL
E-mail: ILL_PSC at mail.wvu.edu


_______________________________________________
ARIE-L mailing list
Post at ARIE-L at u.washington.edu
Unsubscribe at http://www.arie-l.org#subscribers