compare named ranges and list duplicates

's Computer Specifications

i have 3 named ranges (three different sheets)...
Need to compare named range 1 (NR1) vs named range 2 (NR2).
If a number is found in both ranges, list it in range 3 (NR3).

's Computer Specifications

nr_one
nr_two
nr_three

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
a data validation list that contains a list of named ranges - not alist from a named range	BoringAccountant	Microsoft Excel Worksheet Functions	1	9th Jul 2010 12:12 AM
Named ranges scope / workbook/worksheet level named ranges- changeswith variable use...	christian_spaceman	Microsoft Excel Programming	3	24th Dec 2007 01:15 PM
Getting list of named ranges	DZ	Microsoft Excel Programming	3	10th Dec 2007 01:07 PM
Compare named ranges	test.file@gmail.com	Microsoft Excel Programming	6	10th May 2006 08:39 AM
Compare named ranges	test.file@gmail.com	Microsoft Excel Worksheet Functions	6	10th May 2006 08:39 AM