User Profile
OliverScheurich
Gold Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: Excel
Thank you! I'm using Edge and Windows 11 as well and i didn't remember the gear menu item that is available for me as well. I was only looking for the menu (three dots) as it's shown when replying to a discussion. I've tried attaching a file several times to the discussion i've started but the attachment is removed unfortunately. EDIT: I was able to attach a small file ( ~11 KB) to my initial post of this discussion. However this isn't reliable since all other files were deleted. It seems that only small attachments aren't deleted no matter if i reply to a discussion or if i've started the discussion. Another EDIT: It seems that .xlsx files with up to 75 MB can be attached and aren't deleted and that all macro-enabled files .xlsm can't be attached from my PC.Re: Excel
If i've started the discussion i don't have a menu where i can choose to edit or delete the original message. The menu is only shown for the answerer. If i've replied to a discussion then there's a menu where i can edit the message and attach a file. To the discussion below i've replied yesterday and my attached file didn't stick. Today i've edited the message and attached the sample file and it's working for me.Re: pulling changing number of rows into another sheet, where you have categories in rows
=IFERROR(INDEX(A$2:A$32,SMALL(IF($C$2:$C$32="Shenzhen",ROW($C$2:$C$32)-1),ROW(A1))),"") Is this similar to what you are looking for? The formula is in cell I2 and dragged across range I2:N10 and works in all versions of Excel. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2024. The formula works across two sheets as well. For illustration i've made an example within one sheet. With recent versions of Excel you can use the FILTER function to simplify the solution.Re: Filter Function or any Logic
I've found your sample file in an earlier thread. However there is only one rnti in your sample file that is 384. I've attached your sample file "Filter_Function.xlsx" with suggested code. For my sample data there are now 2 queries as shown in the screenshot. One query returns the final output and the other query shows the intermediary step that includes the "spdu-" column. My sample file is "Filter Function or any Logic.xlsx".Re: power query/ dax measure , multiple conditions/ multiple answers
An alternative could be Power Query. In the attached file you can add data to the blue dynamic tables. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.Re: unpivot from columns to rows in power query
let Source = Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content], #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Naam"}, "Attribut", "Wert"), #"Added Index" = Table.AddIndexColumn(#"Unpivoted Other Columns", "Index", 0, 1), #"Added Index1" = Table.AddIndexColumn(#"Added Index", "Index.1", 1, 1), #"Merged Queries" = Table.NestedJoin(#"Added Index1",{"Index.1"},#"Added Index1",{"Index"},"Added Index1",JoinKind.LeftOuter), #"Expanded {0}" = Table.ExpandTableColumn(#"Merged Queries", "Added Index1", {"Wert"}, {"Wert.1"}), #"Inserted Modulo" = Table.AddColumn(#"Expanded {0}", "Modulo", each Number.Mod([Index], 2), type number), #"Filtered Rows" = Table.SelectRows(#"Inserted Modulo", each ([Modulo] = 0)), #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Attribut", "Index", "Index.1", "Modulo"}), #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Wert", "employee"}, {"Wert.1", "share employee"}}) in #"Renamed Columns" The M code above returns the output in the green result table with basic transformations. The name of the blue table is "Tabelle1".Re: How do I propagate info from Master Tab to Other Tabs
Are these names of real people in your screenshot? If so please remove the screenshot. Thank you. File Attachments | Microsoft Community Hub =FILTER(Masterlist,Masterlist[Council]="Monday") I'd turn the Masterlist into a dynamic table and apply the FILTER function in the subsheets. I can't attach a sample file therefore i've added a screenshot that shows the result within the same sheet. The formula works across sheets as well. If you don't have access to the FILTER function i can suggest a solution that works in legacy Excel such as Excel 2013.
