Last seen: Jun 12, 2026
You could use: =SUMIF(C8:C17,"<>",D8:D17)
Filters work by hiding entire rows. You can't filter one table without affecting the visibility of any adjacent cells. You might be better off using a...
If you want to use a number, you should either use some sort of lookup function within the formula that calls the UDF, or also pass the cells that con...
Is it possible to replace "GAM83MALE" with a cell reference? Yes. You could use INDIRECT(cell_reference) in the function call, assuming that the ...
Your Application.Goto line can't work since you can't use brackets in the name of a range - so it can't be called "ArrayMortality()" - and you can't s...
You could use code like this: Sub ListTable1Queries() Dim q As WorkbookQuery For Each q In ThisWorkbook.Queries If InStr(1, q.Formula, """Table1"""...
You could add an Index column starting at 1. Then add a calculated column using the index column thus: Number.Mod([Index]-1,15)+1) whi...
You can specify those as arguments for the protect command: Sheet1.Protect Password:="password here", AllowFiltering:=True, AllowUsingPivotTab...
It sounds like a bug, but try breaking that line up into separate steps like this: Dim sh as Object Set sh = ActiveSheet.Next sh.Activat...
Sorry, it was implicit in this sentence: "the first part of the formula checks if the number of values in the result array is less than the nu...
COUNT(MODE.MULT($B$2:$D$21)) tells you how many numbers are returned by your original function (7 in this example) ROWS($A$1:$A1) returns a sequenc...
If the code is in a worksheet code module, then Range("UP84Male").Value would always refer to a range on that worksheet (this seems unlikely as you'd ...
The error is not actually returned by the formula, which is why IFERROR doesn't work, it's because the result array has fewer 'rows' than the range yo...
I would strongly suggest that you keep the currency code and the actual value as separate cells.
You're missing about 9 End If lines, since you have nested all your If clauses within each other. It's hard to be sure without the workbook (all you n...