How to dynamically set the data range for the LARGE function (or any function really)?

My data looks like this:     I am trying to have the data range or "array" dynamically set for the LARGE function (returns the kth largest value in a data set) as I add new column data to th...