Forum Discussion
Adjust a formula to ignore hidden/filtered rows of data
I have a formula already setup to calculate the total occurrences of a unique ID in a column. =SUM(IF(ISNUMBER(A2:A2719)*COUNTIF(A2:A2719,A2:A2719)=1,1,0)) But when I have a filter set on a t...
Thanks, SergeiBaklan .
> Better to apply FILTER() once to shorter array.
What i meant by applying the filter in LAMBDA is not the use of the FILTER function but rather adding an extra condition joined with the visibility test by AND. Are there any disadvantages here?
I'm not sure, that's mainly performance issue. If performance is not the point, do as as it is better in maintenance for you.