Last seen: May 22, 2025
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.
The issue with the SUMPRODUCT and SUMIF construction is that you're basically doing this: SUMIF(E2:E12,K2)+SUMIF(E2:E12,K3)+SUMIF(E2:E12,K4)+... and s...
I'd assume it's your regional settings. You probably need something like: =COLUMNS({123;0})
Your ReadOptionBoxes routine uses the active cell, but your UpdateDisplay routine doesn't move the selection until after it's populated everything. If...