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

 maya -
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?

2 replies

Registration date
Sunday September 12, 2010
Last seen
June 8, 2021
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,
Thanks Trowa, for your valuable time. I solved it myself by referring the column by column numbers. once again , Thank you.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!