Refer only one column from named range [Solved/Closed]

Question

Refer only one column from named range [Solved/Closed]

Report

Maya - Oct 31, 2015 at 07:09 AM
maya - Nov 2, 2015 at 11:40 PM

Hello everyone and thanks in advance!

I have a report in excel 2010. In that i created a named range as "nmerng" which refers two columns say(A:B). I'm wondering is it possible to refer values only from column "A". Does any one have idea to solve this?

Refer only one column from named range
Comparing two columns of names in Excel ✓ - Forum - Excel
Dynamic range and named ranges ✓ - Forum - Excel
Excel - Copy a range if the a specific column is blank - How-To - Excel
Create a reference to the same cell range on multiple worksheets - How-To - Excel
Copy range data in a column to new column. ✓ - Forum - Excel

2 replies

Ask a question

TrowaD · Answer 1 · 2015-11-02T11:36:49-0500

Answer 1 / 2

TrowaD

Posts: 2757
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 8, 2021

462
Nov 2, 2015 at 11:36 AM

Hi Maya,

Not sure what the issue is.

You created a named range for column A:B. And now you want to create a named range for column A. Since you can have a named range for both A:B and A, what is stopping you?

Best regards,
Trowa

maya · Answer 2 · 2015-11-02T23:40:22-0500

Answer 2 / 2

maya
Nov 2, 2015 at 11:40 PM

Thanks Trowa, for your valuable time. I solved it myself by referring the column by column numbers. once again , Thank you.

Refer only one column from named range [Solved/Closed]

2 replies

Your reply

Subscribe To Our Newsletter!