Last seen: Apr 8, 2025
You're welcome & thanks for the feedback.
How about =INDEX(B2:B15,AGGREGATE(15,6,(ROW(B2:B15)-ROW(B2)+1)/(A2:A15=Q2)/(C2:N15=Q3),1))
You're welcome & thanks for the feedback
How about =UNIQUE(FILTER(C4:C10,ISNA(XMATCH(C4:C10,UNIQUE(C4:C10,,1),0))))
.NET Framework 2.0 installed but got the SAME result / problem. In that case I'm not sure why you get that error.
Sounds like you need to install the .NET Framework 2.0 which you can get here
How about Private Sub Worksheet_Activate() Dim vItemCode As Range Dim myArrayLst As Object Set myArrayLst = CreateObject("system.collections.array...
If you have the new LET function how about =LET(Qty,(LEN(A2)-LEN(SUBSTITUTE(A2,"STOP@","")))/5, Sub,SUBSTITUTE(A2,"STOP@","|",SEQUENCE(2,,Qty-1)),T...
You're welcome & thanks for the feedback
How about =SUMPRODUCT(($AF$2:$AF$9=C2:AD2)*($AG$2:$AG$9))
Once again probably not quite what you want, but two options. 1) if you have the LET function =LET(Rng,B2:G47,CHOOSE(SEQUENCE(,COUNT(B2:G2)),SLO...
The problem is that you are using a static range in the COUNTIFS, you need to increment the row like .Cells(thisRow, "E").Value = WorksheetFunction...
To do that you would need to store all the changes that were made, along with cell references, to another sheet.
How about Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim RwOffset As Long If Target.CountLarge > 1 Then Exit Su...