Refer only one column from named range

Solved/Closed
Report
-
 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

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