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

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

"Iftikhar" wrote in message
...
for a data set if the names and roll no are disordered how can we compare
with original list?

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Iftikhar" wrote in message
...
for a data set if the names and roll no are disordered how can we compare
with original list?