Hi all,
I am looking for a point in the right direction with regards to speeding up the process of filtering, copying, and pasting some raw data that I have.
I have a table with all my raw data (based on observations from a tennis match), and at the moment I want to, for example, copy all the data in a certain column when Roger Federer was serving, and his 1st serve went in, and he won the point. I then copy the remaining data in my column of interest and paste it into a new table on another sheet. At the moment I am having to manually filter through the table by selecting the heading and then the results I want to see. As you can imagine this takes some time.
How would I go about speeding this process up using excel formula?
Many thanks in advance,
Marc
I am looking for a point in the right direction with regards to speeding up the process of filtering, copying, and pasting some raw data that I have.
I have a table with all my raw data (based on observations from a tennis match), and at the moment I want to, for example, copy all the data in a certain column when Roger Federer was serving, and his 1st serve went in, and he won the point. I then copy the remaining data in my column of interest and paste it into a new table on another sheet. At the moment I am having to manually filter through the table by selecting the heading and then the results I want to see. As you can imagine this takes some time.

How would I go about speeding this process up using excel formula?
Many thanks in advance,
Marc