Posted to microsoft.public.excel.programming

external usenet poster

Posts: 399

Check for duplicate values?

I've got almost 30 ranges in my worksheet. No value should be duplicated in
any of these ranges. Is there a convenient way, either with a worksheet
function or a VBA method, to monitor this for each range? Or do I need to
loop through each cell of each range on a regular basis to see if I've got
duplicates?

Ed

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Duplicate check	Robzz	Excel Worksheet Functions	4	May 5th 09 02:41 PM
duplicate check	rufusf	Excel Worksheet Functions	2	August 29th 06 04:30 PM
How can I check for duplicate $'s?	MDG	Excel Worksheet Functions	0	January 25th 06 10:01 PM
Check to see if variable is duplicate.	ianripping[_59_]	Excel Programming	7	May 8th 04 11:37 AM
Check for duplicate entries	cstang	Excel Programming	1	July 11th 03 08:02 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us