Last seen: Jul 8, 2026
I can't really relate the error message to the script you copied into your message, but are you sure that the column name is really "Subaccount" at th...
If you happen to be an MS365 subscriber AND an Insider with access to recently rolled-out functions, this one will do it for you: =SORT(TRANSPOSE(T...
The Source step and Column names used in the query are subject to your own data structure. It it's a structured table, use the correct table name. In ...
As a variant and assuming you want to apply this not only to areas in the table (referring to the screenshot) where the header contains the word "Sala...
You didn't attach a file but I believe it was clear what you needed. Google a bit and come to this site: Used the method described to construc...
When you change the data type don't choose "Currency" directly. The format that the amounts come in is probably not the same as what you have have in ...
Thanks Mynda for pointing that out. Must have missed that last click. Trying again.
If you have Excel for MS365 or 2021 you can fairly easily use a formula based solution with INDEX and XMATCH. But, you explicitly asked for a PQ based...
If you are on Excel for MS365 or 2021, try this: =FILTER(dates,WEEKDAY(dates,1)=1) where dates refers to the range containing the list of dates.
As a variant you could use: =SUM(MMULT((Table1[Size]>=I3)*(Table1[Size]<=I4),--(Table1[[#Headers],[Product A]:[Product E]]=H2&" "&I2)...
Change the formula in N3 to: =ROUND(PRODUCT($F3,SUM(PRODUCT($G3,INDEX(samples,1,MATCH(N$2,t_headers,0))),PRODUCT($H3,$J3:$M3))),0) Copy down and...
You can still return -1 in stead of "", but you would have to change the formula like the one in H2 to: =COUNTIF(Table1[FRD Days],">=0") ...
You either need to calculate workdays within PP (different options to be found on-line) as PP doesn't recognize NETWORKDAYS or you can use a workaroun...
I created a small model that allows you to allocate 120 hrs, linearly over a 12 month period. The principle here is: ( First + Last ) / half the n...
Perhaps the attached file will help you on your way.