Jeffrey Mahoney
Well-known Member
- Joined
- May 31, 2015
- Messages
- 2,797
- Office Version
- 365
- Platform
- Windows
I learned today that I can return a range from the intersect of two ranges by doing this
=3:14 A:W
Returns A3:W14
There is a space separating those two ranges
Now, how do I get the entire row from a range? If I want to return 3:20 if I have a range A3:A20. More important, I want to give it a named range and have it return the entire row of that range.
=3:14 A:W
Returns A3:W14
There is a space separating those two ranges
Now, how do I get the entire row from a range? If I want to return 3:20 if I have a range A3:A20. More important, I want to give it a named range and have it return the entire row of that range.