View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default 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).