Forum Discussion
Using Array Formula with other functions
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 t...
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
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