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?