Last seen: May 22, 2025
I think you want something like this: =IF(COUNTROWS(filter(Table1,Table1[Course Ref]="NG1 Exam"&&Table1[Result]="PASS"))+COUNTROWS(filter(T...
You can filter out the blanks using something like: =CONCATENATEX(FILTER(values(Table1[NG1 Mark]),Table1[NG1 Mark]<>BLANK()),Table1[NG1 Mark]...
You could use something like this: let Source = Excel.CurrentWorkbook(){[Name="source_table"]}[Content], #"Replaced Value1" = Table.ReplaceVal...
You add the calculations as measures in the data model, not using MDX. The MDX only determines what level of detail is shown in the set but you can do...
Add the fields you want calculated to the pivot table, then on the Pivot Table Tools, Analyze tab, use the 'Create set based on row items' option. Tha...
The worksheet_change event is triggered by changing a cell's contents manually. Given all your similar posts, it would probably make sense for you to ...
This is an example of using a row set. I had to amend the MDX manually to make sure it will adjust if new products are added (which was not easy for m...
If I understand you correctly, you could achieve that look with a row set by only showing the field for the totals row.
If you have the new Insider beta functions, it's actually even simpler: =SORT(TOCOL(A1:E6,1)) for example.
This happens when you copy between workbooks that have the same name defined in them. If you want to just accept the default option in the message box...
You could use something like this: Sub Searchable_List() 'Execute search for nestable products Dim CalculatorDraft As Worksheet Dim Previou...
No problem - just wanted to mention it as an alternative. 🙂
With a list of matching column names, you can get the sum using something like: List.Sum(Record.ToList(Record.SelectFields(_, MatchingColumnNames))...
Your Results control is a textbox, but should be a Listbox.
Try: =FILTER(Sheet1!$B$6:$AG$600,ISNUMBER(SEARCH($B$2,INDEX(Sheet1!$B$6:$AG$600,0,MATCH($B$1,Sheet1!$B$6:$AG$6,0)))))