Hi,
I have set of extracted results which I am trying to get max and min summary tables for every nth row for some of the columns.
Data is at rows 6 to 89 and on columns between E to T. I want to get the max (and min) of 6th and 20th row. Then, 7th and 21st row and so on. In the end, I am aiming to get a summary table of 12 rows and 14 columns. What is the fastest way to create several of these summary max and min tables?
Thanks for all the help.
I have set of extracted results which I am trying to get max and min summary tables for every nth row for some of the columns.
Data is at rows 6 to 89 and on columns between E to T. I want to get the max (and min) of 6th and 20th row. Then, 7th and 21st row and so on. In the end, I am aiming to get a summary table of 12 rows and 14 columns. What is the fastest way to create several of these summary max and min tables?
Thanks for all the help.