I have a rows of data that starts at column C and are of varying lengths. ie. some data goes to column F while other data goes to column AY. The data is constantly changing and I would like to perform a MAX function on each row of data without having to change the range manually everytime an extra cell of data is added to the row.
Is there a way that I can look from say cell A3 until I find a blank cell and then return the range that contains data ie A3:AY3 and perform the MAX function on that range?
Thanks
Is there a way that I can look from say cell A3 until I find a blank cell and then return the range that contains data ie A3:AY3 and perform the MAX function on that range?
Thanks