Last seen: May 22, 2025
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 ...
If you're trying to only pick up the new data as a pivot table, you can't do that, since the headers aren't adjacent to the data.
You can't use three criteria arrays (assuming you want all possible combinations) like that. Are there other options in column F that begin with "Trad...
If you're trying to use Worksheetfunction.Filter, the second argument needs to be an array of True/False values and oriented the correct way (ie if yo...