Duplicate Entries

[george]

Hi All
Can Excel somehow detect that you have two same entries within a different
worksheet but in the same file? This may sound a bit ambigous, so here is an
example of what I mean: say I had a file called "my_spreadshit.xls" and with
in it, sheet1 and sheet2 contained some info that was the same. Can I
highlight it or identify it using some search function?
Cheers

 

[Peo Sjoblom]

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

you can use the same technique as in the above link or from the same website
you can download

compare.zip

a utility written by Myrna Larson and Bill Manville

 

[PCOR]

Hi
I tried that code suggested by Mr Pearson.....it works well on
labels.....but not on numbers.
Any idea how to do the same with numbers
Thanks