Duplicate Entries

  • Thread starter Thread starter george
  • Start date Start date
G

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
 
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
 
Back
Top