Question : google sheets formula pull last columns
Answered by : jp
=ArrayFormula( query( {B2:6}, "Select Col"&IFNA(match(2,1/(B2:2<>""))) )
)
Source : https://infoinspired.com/google-docs/spreadsheet/get-the-last-column-from-a-data-range-in-google-sheets/ | Last Update : Tue, 03 May 22