Last seen: Apr 8, 2025
How about =IF(OR(E3>EDATE(TODAY(),-6),E3=""),"","Send to QA")
That formula is pointing to itself & so creating a circular reference. In your original image the dates were in col F, now they are in col E s...
Get.cell does not recognise conditional formatting & even if it did you would need to save the workbook as macro enabled. The simplest thing is...
How about =BYCOL(B13#,LAMBDA(bc,AGGREGATE(9,5,bc)))
Make sure the sheet with the formula is not between the sheets your referencing, otherwise you might get a circular reference.
For B6 you can use =VSTACK(A2,DROP(SCAN(A2,E6#,LAMBDA(a,b,a-b)),-1))
Sorry for the delay in replying, I only got a notification today. The formula you are trying to use if only filtering columns A & B based on co...
Glad to help & thanks for the feedback
I think the problem is the Choose function. Just use =FILTER(Data!$A$2:$B$16,Data!$C$2:$C$16=$C$1)
Another option =MMULT(A1#,SEQUENCE(COLUMNS(A1#),,,0))
Another option =IF($N14="","",INDEX(SORT(FILTER($C$2:$C$17,($B$2:$B$17=$N14)*($G$2:$G$17<=O$13),"NA")),1))
Glad to help & thanks for the feedback.
How about =ROUNDUP(PRODUCT(I5:L5)/10,0)
The code is not responding because you are loading the listbox with an array of 1,000,000 rows. Try it like this instead. Private Sub UserForm...
Change this Dim i, X As Integer to Dim i As Long, X As Long