LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
filtering out rows with duplicate information rfIPS Excel Discussion (Misc queries) 1 March 6th 07 07:51 PM
process of elimination of duplicate information Manny Excel Discussion (Misc queries) 3 December 14th 06 03:13 PM
Duplicate information Lloyd Excel Worksheet Functions 1 November 24th 06 10:49 AM
merging information from partial duplicate rows Todd Excel Discussion (Misc queries) 3 August 25th 06 10:02 PM
Duplicate information Stephanie Excel Discussion (Misc queries) 1 March 31st 05 10:44 PM


All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"