Can we Merge two Separate Ranges in two Different Sheets by means of Assigning a Name under Name Manager?

L

LearnExcl

Board Regular
Joined
Mar 17, 2010
Messages
245
Office Version
  1. 2016
Platform
  1. Windows
Hello,

Trying to assign a name using the Name Manager for two separate ranges in two separate sheets, which would essentially merge the two. Ranges are A2:A1000 in Sheet1 and C2:C1000 in Sheet2. This named range will then be used in a formula to extract the unique values off of the two ranges merged via the named range.

Is this doable? Any and all help will be appreciated.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
You must log in or register to reply here.

Similar threads

R
  • Question Question
Smarter alternative to Name Manager & Indirect Formula?
Replies
1
Views
327
RoryA
RoryA
J
  • Solved
VBA to compare rows in two different sheets, if match highlight cell
2
Replies
10
Views
1K
kevin9999
K
O
  • Question Question
Excel/VBA to conditionally send emails per schedule
Replies
0
Views
942
OC2PS
O
B
  • Solved
VBA to save one file as multiple files in location
Replies
7
Views
1K
bh24524
B
HansM
  • Question Question
Looking for a specific number in a cell that can have multiple numbers separated by a comma (Using Mac Excel)
Replies
5
Views
290
Jeffrey Mahoney
Jeffrey Mahoney

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top