LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Related to MS Excel

Dear Professionals,
I have two excel files. File 1 and File 2. I want to compare both files and list all those records which are not in file 2 and same thing with file 1.

Views: 145

▶ Reply to This

Replies to This Forum

Permalink Reply by Dr. Badan Barman on September 22, 2010 at 23:02
Copy all contents from file 1 to file 2.
Save the new file under the name of file 3.
Sort all the entries of file 3 in A-Z.
Delete the duplicate entry manually.
Permalink Reply by Dinesh Ranjan Pradhan on October 3, 2010 at 23:41
If you have to filter the records by one specific column you can try the below link

http://support.microsoft.com/kb/213367

RSS

© 2024   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop