Last seen: Jun 10, 2026
You shouldn't need that measure actually in the chart at all.
Without rearranging the data, you can do something like: =SUMPRODUCT((XLOOKUP(A3:A17,E3:E17,F3:F17)="notebook")*B3:B17) to add up Irene's notebo...
You could create a measure called ItemsSoldNoZero with the formula: =if([Sum of Items sold]=0,blank(),[Sum of Items sold]) Then amend your ...
I'd use SaveCopyAs then open the copy if you really need both open: activeworkbook.savecopyas newfile workbooks.open newfile
Glad we could help. 🙂
GetOpenFilename doesn't open workbooks. It appears that all you need is to amend the original code to something like this: With Application.FileDia...
Which version of Excel do you have?
For others reading, it appears from the link that this was down to user error, so no need to follow up on this one. 🙂
The Plot column in your Table2023 query is set to Any, not number.
The values in Table2023 are text, not numbers. You could amend your formula to use Table2023[Plot]+0=[@Plot] as the criterion. The +0 will coerce the ...
I think you misunderstood. There is nothing in that code that adds any sort of hyperlink. What I am asking is how would you do it manually? Th...
How would you do it manually? I'm not aware of any hyperlink options to link to a specific email.
A GETPIVOTDATA formula would be more efficient and doesn't care about the pivot table layout (as long as the specified value cell appears in the pivot...
For a pure formula approach, if you sort the data on column G and then use: =IF(G2=G1,J1,COUNTIF(G:G,G2)) copied down, that should be considerab...
Performing 800k calculations, all but 362 of which are repetitions, is not very efficient. I'd suggest you either sort the data first to that you only...