What I want to do is to count all the cells in each column where the value in the top row starts with a given value and the cell contains a given value; for example the header starts with an 'A' and the cell contains with an x. I know h...
I am running this FILTER formula to sum distinct values in 'June' column D based on criteria in 'June' columns Q and C. I get only an "empty array" error. =SUM(--(LEN(UNIQUE(FILTER('June'!D:D,('... Riny_van_EekelenThank you! For the record I used the COUNTA function as ...
Is the filter in CALCULATETABLE applied to the "VALUES()" table or the original Files[tag] table before the VALUES function does its thing? Becaue if it's applied after values(), then wouldn't it just be the same as selectedtags, since the table after values contains ...
Is the filter in CALCULATETABLE applied to the "VALUES()" table or the original Files[tag] table before the VALUES function does its thing? Becaue if it's applied after values(), then wouldn't it just be the same as selectedtags, since the table after values contains ...
Hello, I don't know if this is possible, I have a very unique situation. We use Excel for our test cases, usually multiple sheets in one file. The main...
Is the filter in CALCULATETABLE applied to the "VALUES()" table or the original Files[tag] table before the VALUES function does its thing? Becaue if it's applied after values(), then wouldn't it just be the same as selectedtags, since the table after values contains ...
=COUNTA(UNIQUE(FILTER(E:E,(June!Q:Q>=$D$18)*(June!C:C=110))) Up to you to determine if this is what you want. If it is not, perhaps you can upload a schedule that demonstrates your real situation and indicate the results you would want to see. As...
Is the filter in CALCULATETABLE applied to the "VALUES()" table or the original Files[tag] table before the VALUES function does its thing? Becaue if it's applied after values(), then wouldn't it just be the same as selectedtags, since the table after values contains...
Is the filter in CALCULATETABLE applied to the "VALUES()" table or the original Files[tag] table before the VALUES function does its thing? Becaue if it's applied after values(), then wouldn't it just be the same as selectedtags, since the table after values contains ...