Last seen: Jun 10, 2026
Your initial sample suggests you don't care about which year it is, just the month name - is that correct? I think it's probably simplest just to g...
Been there, done that. 🙂 Very easy to get fixated on a specific path...
Isn't it just: =AVERAGEIF($A$1:$A$60,"<="&SMALL($A$1:$A$60,10))
Put the Set outMail =… line before the With outMail line.
Your IT department should be fired - that's pretty basic stuff. 🙂 You need to put this line: Set OutMail = OutApp.CreateItemFromTempl...
You have duplicate rows in the Sales Allocation2 COL sheet.
Remove this line: Set OutMail = OutApp.CreateItem(0) Do you not have distribution lists at work?
It would probably make more sense to do all of this in the original query, but you have removed the queries which makes that a little tricky. 😉
That particular dialog is for choosing a file, not a folder, and you didn't specify the InitialFileName property for the dialog anywhere. It w...
This part of your code to set the file name: Range("U23").NumberFormat = "mm-dd-yyyy" will return True/False depending on the numberformat appli...
You have a lot of the same calculations repeated in those formulas. I would move the lookups to a new row above the columns, and add the factored tren...
You can add that in like this: =IFERROR(AVERAGE(FILTER($D$2:$D$2382,COUNT(SEARCH({"assistant","supervisor","floor"},$C$2:$C$2382))*($a$2:$a$2382="s...
If you have the FILTER function available, you could use: =IFERROR(AVERAGE(FILTER($D$2:$D$2382,COUNT(SEARCH({"assistant","supervisor","floor"},$C$2...
Hi Alan, It would be: let Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID"...
When doing the replace values step(s) you should leave the 'value to find' box blank and put null in the replace with box.