User Profile
Hogstad_Raadgivning
Iron Contributor
Joined 10 years ago
User Widgets
Recent Discussions
VSTACK tables with different number of columns
Hi, I have 2 tables with different number of columns and that cause the text string to cut, because columns with errors is added to that table in VSTACK. I Can use IFERROR and hide the errors. But it still cut my text. Is it possible to wite the formula so it does not cut the text? See attached document for example. Best Regards GeirFilter columns by criteria, dynamic spilled/list.
Hi, For each row in a dynamic range, I want to filter/select the headers if it is a "X" in the line column. I made it work with Filter. But I dont get that to be dymamic for each row in the list. =TAKE(FILTER($T$8:$AD$10;'Ark1'!T23:AD23="x";"");1) Filter might not be right function here. Any better solutions? Best regards GeirMissing Security option, to unlock sheet with macro.
Hi. I have a sheet with macros, but I can not find how to enable Excel to run macros on the file. Saved at Sharepoint. My documents options settings does not have security option. Any sugestions, how to enable macros in this document? Best Regards Geir
