how can we compare name and roll no lists

[Iftikhar]

for a data set if the names and roll no are disordered how can we compare
with original list?

 

[Bill Ridgeway]

There are a number of ways to answer your query dependent on what you're
wanting to do.

Are you wanting to compare and eliminate duplicates? Is data entered in
both in exactly the same way?

Regards.

Bill Ridgeway
Computer Solutions

 

[Ragdyer]

Check out this link to Chip Pearson's web site.
Scroll down to the D's, and you'll find several pages that deal with
handling duplicates.

http://www.cpearson.com/excel/topic.htm