Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm

And Debra Dalgleish has lots of info about =match():
http://contextures.com/xlFunctions03.html

Aslam wrote:

hi;

Can any help how to compre two sheets with same data in both sheets by
Match function

thanks
sg

--

Dave Peterson