Home

Using Array Formula with other functions

Highlighted
TerenceSweeney
Occasional Visitor

Hi All

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)

 

 

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).

 

I came across the Array formula function but cant seem to find a way to a solution.

 

Am I missing something or is there an easier way to create this?

 

Screen_Shot_for_Array_Formula_Question.png

1 Reply
Highlighted
Hi Terence,

The simplest approach is to highlight your block of data (A1 to F3) and turn it into a Table using Ctrl+T
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

Related Conversations
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
Serverless Compute Survey
MacKenzie997 in Compute on
0 Replies
Array Formulas Syntax - Matrix Calculations
ignacioch in Excel on
0 Replies
Leap year formula
Hattsoff in Excel on
4 Replies