Last seen: Jun 12, 2026
Can you post a sample workbook? It may be possible to do what you want with a consolidation range pivot table, if you can't download Power Query or Po...
As a matter of interest, why are capital letters important? SUMIF(S) wouldn't care about case.
Why have you used IFS in every cell? IFS is not particularly efficient as it evaluates all the criteria expressions and all the value expressions no m...
It is the version. If Excel 2016 has the problem, I'd guess you are using a function that is restricted to subscription versions/Excel 2019. Why don't...
It's never really a good idea to change the defaults from whatever the user has set, since if your macro fails for any reason, you will have messed up...
Sunny has already given you a great answer, but since I'd done it anyway, and in case your data set isn't sorted, you could also try this: Sub...
It looks like you just need SUMIFS: =SUMIFS($B:$B,$D:$D, "Yes", $C:$C, ">="&A2, $C:$C, "<"&A3 )
Which version of 2013? If it's Professional Plus, or Excel standalone, you should have Power Pivot. If it's a different version, you cannot use it and...
Depending on what version of Power Pivot you have, you may be able to use CONCATENATEX for this:
The Text property just returns a String, which doesn't have formatting. You'd have to parse the Characters one by one and add the relevant HTML or RTF...
You could use a class, declare a MailItem object WithEvents and handle its Close event, checking its Sent status then, as long as you can set a refere...
Probably something like: =IFERROR(VLOOKUP($BC$1;$CD$3:$CF$14;2;FALSE)&" - "&VLOOKUP($BC$1;$CD$3:$CF$14;3;FALSE);IFERROR(VLOOKUP($BC$1;...
It seems to be a limitation in Mac Excel (I"d call it a bug).
This should be the same effect as your original code but pasting column widths too: Sub SplitIntoSeperateFiles() Dim OutName As String OutName...
It sounds like you just need to change the formula to: =IF(C4=”Staff costs (direct and external)”,M4 *0.15,0)