Last seen: Sep 19, 2025
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...
You can define a named range, WeeklyDPMO as: =Sheet1!$J$9:INDEX(Sheet1!$J$9:$J$13,COUNT(Sheet1!$J$9:$J$13)) (adjust to match your real work...
Can you clarify the "when I graph all the data" comment? Charts will only generally ignore blank cells (no cell that contains a formula is truly blank...