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" <(E-Mail Removed)> wrote in message
news27E18CE-52A0-4EDA-A30C-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news27E18CE-52A0-4EDA-A30C-(E-Mail Removed)...
> for a data set if the names and roll no are disordered how can we compare
> with original list?
>