Refer only one column from named range

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?

2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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,
Thanks Trowa, for your valuable time. I solved it myself by referring the column by column numbers. once again , Thank you.