View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Find Duplicate Information

Hi,

I was wondering if it were possible to have a macro that searches each
column, Ranges A1:A5, for duplicate numbers/information/values before I close
the spreadsheet and then have it alert me when it finds any? If it is, does
anyone know where I can get a macro like that? Heck, I wouldn't mind if I had
to run it manually either, just something that can find dups without me
having to eyeball hundreds of lines through five columns.


Thanks Very Much In Advance,
Rob