ExcelBanter - compare named ranges and list duplicates

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - compare named ranges and list duplicates (https://www.excelbanter.com/excel-programming/443744-compare-named-ranges-list-duplicates.html)

J.W. Aldridge

compare named ranges and list duplicates

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).

J.W. Aldridge

compare named ranges and list duplicates

nr_one
nr_two
nr_three

All times are GMT +1. The time now is 09:21 AM.