After autofiltering data and while the autofilter is open, is there any way to refilter the data. For example, after filtering 100 rows down to 5 rows, I would like to find the second highest of the five (not the second highest of the original 100).
I know it can be done by copying and pasting the filtered data to another sheet and then running the large function to find the second largest. I would prefer a simpler and more elegant way to do this. The result of this operation will be assigned to a variable and then no further use is needed for the filtered data.
I know it can be done by copying and pasting the filtered data to another sheet and then running the large function to find the second largest. I would prefer a simpler and more elegant way to do this. The result of this operation will be assigned to a variable and then no further use is needed for the filtered data.