Home

Using Array Formula with other functions

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
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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies