Last seen: Jun 11, 2026
If you have BYROW available to you, you could use: =BYROW(A3#,LAMBDA(a,(INDEX(STOCKHISTORY(a,EOMONTH(TODAY(),-4)-1,,2,0),1,2)-INDEX(STOCKHISTORY(a...
The samples provided don't actually have any matches, so it's hard to say why your formula isn't working with your real data, other than that presumab...
Image controls do not have scrollbars. I suggest you use a listbox or similar instead.
If you're using the data model, you can specify the number format for measures and it will apply whenever the measure is added to your pivot.
For a situation like this, it's probably simplest to just suppress the errors using something like: On Error Resume Next With ActiveSheet.ChartO...
Maybe something like this: let Source = Excel.Workbook(File.Contents("C:path to your file herePRE.xlsx"), null, true), PRE_Sheet = Source{[Ite...
0.2 rather than 0.02 I think. 😉
You can work out the offset between the cell's Column property and the Listobject.Range.Column, which will tell you the listcolumn number. From there ...
You can't format part of a formula result, so the formulas in column L on the Active projects tab would have to be converted to values - is that going...
In f4: =INDEX(Lists!$C$4:$D$18,MATCH($B4,Lists!$B$4:$B$18,0),MATCH($C4,Lists!$C$3:$D$3,0)) and copy down. In G4: =INDEX(Lists!$E$4:$F$18,MATC...
Just add an index column starting at 1.
You could also use something like: =SUM(COUNTIFS(B:B,{"Dog","Donkey"},C:C,"Black"))
You'll need something like this: Option Explicit Sub MakeFolders() Dim Folder As Range Dim FolderPath As String FolderPath = Range("MakeFolde...
The basic code could be something like this: Dim counter as long for counter = 1 to 4 Dim RunningTotal as Double RunningTotal = Runni...