Last seen: Jun 10, 2026
Oh yes. I hadn't spotted that the values in columns D:I depend on the values in columns J:S of the row above. I think this should fix the problem: ...
I'd guess it's a floating point issue. You could also use Number.Round(([End]-[Start])*10+1,0) directly within the List.Numbers function.
I think this works: K19: =IF(ROW()<MATCH(K$7,$H:$H,0)+9,"",IF(MOD(ROW()-MATCH(K$7,$H:$H,0),91)<9,"",K$9/2)) and copy across and down.
Changing the colour of a cell does not trigger any events that you can respond to. If you can, you would be far better off using an additional column/...
That's exactly the approach the formula I suggested uses, but without the helper column. If the helper column is OK, it's probably a better option. 🙂
You could try something like: =COUNTA(UNIQUE(FILTER(Table1[Column1],SUBTOTAL(103,OFFSET(Table1[Column11],ROW(Table1[Column1])-MIN(ROW(Table1[C...
Your code checks the last 52 characters to see if they match "xlsm" (which they can't), then the last 50 characters to see if they match "xlsb" (again...
HI Alan, That's odd - I just tried it again and it worked as posted (64bit 365). Would you mind testing this slight alteration? let Source = Ex...
Look at the controls on the form - do any of them look right to you? They all look distorted and they appear much bigger than their properties suggest...
Yes, you can use something like this: let Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], #"Grouped Rows" = Table.Group(Sourc...
It sounds (and looks) to me as though there may be some corruption in your workbook. I'd suggest rebuilding it.
How big is your monitor? Your userform is over 6k pixels wide, which makes it extremely hard to use!
You can add the path in: Name ActiveSheet.Range("C2") & ActiveSheet.Range("C4") As _ ActiveSheet.Range("C2") & ActiveSheet.Range("C6")
You can also use INDEX supplying 0 as the row number argument - for example: =INDEX(I1#,0,3) returns the third column of the spilled array start...
Or use & consistently rather than + for concatenation. 🙂