New answers tagged worksheet-function
The issue here is that Google Apps Script (used to create the Power Tool add-on) is "blind" to filtered rows. In other words, when you select a range to apply the tool, you are actually selecting the entire range, including the ones that have been filtered out. A clunky workaround would be to select the relevant range while in a filtered view, copy it, ...
Top 50 recent answers are included