Discussion Using Array Formula with other functions in Excel
https://techcommunity.microsoft.com/t5/excel/using-array-formula-with-other-functions/m-p/325391#M24556
<P>Hi All</P><P>I have a spreadsheet which takes a students details and subject scores. I then have a column which returns the name of the students highest subject. (See image)</P><P> </P><P> </P><P>The formula works for the first row. I would however like the formula to also return a value as other rows are added for new students (without having to copy down the formula each time).</P><P> </P><P>I came across the Array formula function but cant seem to find a way to a solution.</P><P> </P><P>Am I missing something or is there an easier way to create this?</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="Screen_Shot_for_Array_Formula_Question.png" style="width: 666px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/70893iC64A131D7103C672/image-size/large?v=v2&px=999" role="button" title="Screen_Shot_for_Array_Formula_Question.png" alt="Screen_Shot_for_Array_Formula_Question.png" /></span></P>Fri, 25 Jan 2019 04:21:29 GMTTerenceSweeney2019-01-25T04:21:29ZUsing Array Formula with other functions
https://techcommunity.microsoft.com/t5/excel/using-array-formula-with-other-functions/m-p/325391#M24556
<P>Hi All</P><P>I have a spreadsheet which takes a students details and subject scores. I then have a column which returns the name of the students highest subject. (See image)</P><P> </P><P> </P><P>The formula works for the first row. I would however like the formula to also return a value as other rows are added for new students (without having to copy down the formula each time).</P><P> </P><P>I came across the Array formula function but cant seem to find a way to a solution.</P><P> </P><P>Am I missing something or is there an easier way to create this?</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="Screen_Shot_for_Array_Formula_Question.png" style="width: 666px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/70893iC64A131D7103C672/image-size/large?v=v2&px=999" role="button" title="Screen_Shot_for_Array_Formula_Question.png" alt="Screen_Shot_for_Array_Formula_Question.png" /></span></P>Fri, 25 Jan 2019 04:21:29 GMThttps://techcommunity.microsoft.com/t5/excel/using-array-formula-with-other-functions/m-p/325391#M24556TerenceSweeney2019-01-25T04:21:29ZRe: Using Array Formula with other functions
https://techcommunity.microsoft.com/t5/excel/using-array-formula-with-other-functions/m-p/325515#M24560
Hi Terence, <BR /><BR />The simplest approach is to highlight your block of data (A1 to F3) and turn it into a Table using Ctrl+T<BR />Then double click in F2 and press enter. Your formula should then copy down and will continue to copy down as you add new students<BR /><BR />Fri, 25 Jan 2019 11:53:37 GMThttps://techcommunity.microsoft.com/t5/excel/using-array-formula-with-other-functions/m-p/325515#M24560Wyn Hopkins2019-01-25T11:53:37Z