Notifications
Clear all
Topic starter
hi Guys,
i am trying to create table with one column from named range:
What i am trying :
= #table({"Column1"}, {Excel.CurrentWorkbook(){[Name="MainNR"]}[Content][Column1]{0}})
but i am getting error.
Why?
how to get value for row using named range?
Best,
Jacek
Posted : 04/09/2021 3:49 am
#table needs lists as arguments.
This is already a table:
Source= Excel.CurrentWorkbook(){[Name="MainNR"]}[Content][Column1]
You don't need {0}, this means a single cell.
Posted : 04/09/2021 6:32 am
Topic starter
Thank you Catalin!
Have a blessed day!
Jacek
Posted : 04/09/2021 6:45 am