Last seen: Jun 12, 2026
Do you have any workbooks loaded that have userforms with controls linked directly to cells (using controlsource property)? That could cause exactly w...
Also note that you can't use Scripting.Filesystemobject on a Mac, and Dir doesn't always work terribly well either.
So you want one new textbox per click of the button? Where should it be placed?
If it's a regular pivot table (non data model) and all the data in that field is numeric, then there should be a number format button at the bottom of...
I think this works: =SUM(--(FREQUENCY(IF(SUBTOTAL(3,OFFSET(Table1[ID],ROW(Table1[ID])-MIN(ROW(Table1[ID])),0,1)),COUNTIF(Table1[ID],"<"&...
They should see a #NAME? error and the function will be prefixed with _xlfn in the formula bar. Edit: the above is what will happen if the for...
Frans, I assumed that, which is why I suggested using event code to automate the hiding/showing of rows. I'm not clear on why side-by-side would...
Since most people have their monitors in landscape orientation in my experience, I'd probably put them side by side but, if you want them under each o...
I suspect you just forgot to name the module you borrowed JSONConverter
As mentioned on other forums where this was posted, you can't use Rowsource for a listbox (or combobox) on a Mac.
SUMIFS won't work for that, you will need SUMPRODUCT. It won't be that much less efficient assuming you only refer to the necessary ranges and not ent...
Something like this would work if you had shapes for every country listed in column A (you don't currently): Private Sub Worksheet_Change(ByVal Tar...
FWIW, since your table appears to be sorted by Team and then points value, you could also use: =IFERROR(LOOKUP(2,1/(Levels[Team]=A2)/(Levels[Total ...
No, it just means that you only need: =SUMPRODUCT((C$2:C$12=$K$2:$K$12)*$K$2:$K$12) rather than: =SUMPRODUCT(--(C$2:C$12=$K$2:$K$12)*$K$2:$K$...
That's because they're the only ones with repeated values in column K.