Automate value selection

Question

Hi all,I have created the table seen below in figure 1 and would like to automate the procedure of creating table 2. Where the maximum forward force at each of the reference speeds is being used.Any help would be appreciated!Figure 1&nbsp;figure 2&nbsp;&nbsp;

harun24hr · Answer

Can you please share the file so that we can work on that. Can't copy paste data from image.

brad_c43 · Answer

Hi Harun,Please see attached, thanks for the help!

harun24hr · Answer

If you want MAX speed by gear then could try one of the following-=GROUPBY(TOCOL(D5:I17),TOCOL(J5:O17),MAX,0,0)
=GROUPBY(TOCOL(CHOOSECOLS(R5:AC17,SEQUENCE(1,6,1,2))),TOCOL(CHOOSECOLS(R5:AC17,SEQUENCE(1,6,2,2))),MAX,0,0)See the attached file.

brad_c43 · Answer

Hi Harun,Apologies for such a delayed response and thanks for your help. My aim here is to have the highest forward force at each velocity, i.e. stay in 1st gear until the forward force at the corresponding velocity in the second exceeds that of 1st. I don't need to utilize every value on the table.

Forum Discussion

Automate value selection

4 Replies