I haven't figured out how to return the filtered value into a specific cell.
I have a large spreadsheet where I filter 3 specific columns and I need those
3 specific filtered values (which are text) to be display in a different area
of the same spreadsheet in a specific cell. It think it may be similar to
the subtotal function which only adds the filtered values =subtotal(9,Range)
but I've been searching only with no success yet. Thanks.