Last seen: Jun 12, 2026
Add a column with 1s in it and another column that multiplies the Total Amount column by this new column. Then change N2 to total the multiplication c...
Since you essentially need to test every possible combination of values, you'll need a recursive routine such as the one posted a little over halfway ...
What are the constraints? What if more than one combination adds up to the value in question? (this is a considerably more complicated question than t...
Since your data appears to be sorted on column A, perhaps this formula in C3: =IF(OR(A3=A2,A3<>A4),"",IF(COUNTIFS($A4:$A$4914,A3,$B4:$B$...
By the sounds of it, you want a formula for the criteria, in which case you don't want the criteria header cell to match any columns (better to leave ...
Unfortunately, the Window.RangeFromPoint method seems to return the shape rather than the range underneath but if you can work with a slightly hacky w...
They're not the most flexible things, but can be handy on occasion. 🙂
You can get the desktop path using: createobject("Wscript.Shell").specialfolders("desktop") so you could use: dim savedFile as...
What you could do with a Power Pivot PT is to create a measure to average the monthly totals (eg =AVERAGEX(values(Table_after_Power_Query[month]),[Tot...
Try this: Sub Macro1() ' ' Macro1 Macro ' ' Dim Colour Colour = ActiveCell.Interior.Color Application.ScreenUpdating = False With Range("B5...
In my opinion, you'd be better off rethinking your approach. Formatting should reflect data, not be used as data.
Hi Nadine, That part works out the number of days between the end date of one row and the start date of the next row, assuming the employee id is t...
This array formula is slightly shorter, but very dependent on the layout of the source data sheet! (Must start in row 1, and be 5x3 blocks with a blan...
If your data is sorted like the sample, and you don't mind the consecutive totals appearing at the end of the sequence rather than the start, you coul...
I don't give out contact info, I'm afraid. As I mentioned before, you cannot use more than two arrays in a formula like this. I would suggest ...