• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to match data in two different excel files

sanjeev kumar

sanjeev kumar

New Member
I have to different excel sheets. I want to compare data matching some word not exact word or sentence.

for Example:
Sheet 1


1. Encyclopedia of special education: A Reference for the education of children, adolescents and adults-
2. Disabilities and other exceptional individuals.4/ed ( 4 vol set )
3. Assessing learners with special needs:An applied approach.6/ed
4. Exceptional children:An introduction to special education.6/ed


Sheet 2

1. Amin, N. (2002). Assessment of Cognitive Development of Elementary School Children. A Psychometric Approach, Jain Book Agency, New Delhi.
2. Chauhan, S.S. (2013). Advanced Educational Psychology. Jain Book Agency, Delhi.
3. King-Sears, E. M. (1994). Curriculum-Based Assessment in Special Education Singular Publishing Group, San Diego, CA.
4. Panch, R. (2013). Educational Psychology: Teaching and Learning Perspective,McGraw Hill Education (India) Private Limited, New Delhi.
5. Paul, P. (2009). Language and Deafness. Singular publication.

Note:
Is there any way to highlight row in sheet 2 matching any word from sheet 1.
 
Hi:

Yes, you can do this. First you should create an exhaustive list of Keywords you want to compare and by using lookup formula you compare and flag those rows where the keywords are matching. Upload a dummy workbook with relevant keywords and data if you need assistance.

Thanks
 
First create an exhaustive list of Keywords with wildcard pattern i.e. adding wildcard before and after each text in list of keyword. Also header of exhaustive list should be same as header name in your data. Then apply advance filter and select raw data in List range and select exhaustive list in Criteria range, it automatically filter the required data as per exhaustive list.

Regards,
Arbind Gaba
SLA Consultants India
 
You must log in or register to reply here.
Back
Top