M
Michael Raphael
I have a list of 20 items that I want to use Auto Filter to determine the top 3 and bottom 3 scores, with ties. I find that Auto Filter is perfect for it.
My question is if anyone knows if there is a way to have the Auto Filter function results be copied to another location?
I've tried to use the Advanced Auto Filter and copy but so far it will only copy the entire list as it does not filter first.
Any suggestions or ideas.
Thanks,
Mike Raphael
My question is if anyone knows if there is a way to have the Auto Filter function results be copied to another location?
I've tried to use the Advanced Auto Filter and copy but so far it will only copy the entire list as it does not filter first.
Any suggestions or ideas.
Thanks,
Mike Raphael