Last seen: May 22, 2025
What version of Excel do you have?
Calculated Items are calculated columns in the data model, not measures (which are the equivalent of calculated Fields.)
To work with your current version: =COUNT(1/FREQUENCY(IF($A$2:$A$26=A34,MATCH($B$2:$B$26,$B$2:$B$26,0)),MATCH($B$2:$B$26,$B$2:$B$26,0))) array e...
FYI, you are slightly mistaken in your belief that advanced filter generally looks for exact matches. For text values, it actually looks for anything ...
It's not clear to me what result you want. INDEX takes three arguments (at most): a range, a row number and a column number. Since your named ranges a...
FWIW, the syntax to Table.AddIndexColumn changed to add a new fifth parameter (the columnType), which is why Mynda's version doesn't work in 2016.
How exactly do you download the data set?
It looks to me as though you can do it without altering the table structures by using: =SUMPRODUCT(COUNTIFS(Features[T-Shirt Estimate], G$16, Featu...
But you can't have multiple files with the same name open in the same Excel instance.
Gary Buglass said In the example above, Row 22 is not equal or less than : 2nd June is after the due completion date of 29 May I know - that's w...
Where do you get 5 from? Only the first 5 rows have a due date less than or equal to 29-May-20 and the actual completion date in row 22 is after 29-Ma...
Row 10 is the top row of your table, and you can't use formulas in header cells, which is why they are disappearing. I'm not quite sure where it is ge...
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?