Google Sheets -CHOOSEROWS & CHOOSECOLS FUNCTIONS EXPLAINED
This video explains the CHOOSEROWS and CHOOSECOLS functions in Google Sheets, these functions are used to return the specific row number(s) or specific column number(s) from an array of data. I also show you in the last example how to automate it and use it with the match function and dropdown.
By the end of this video, you will know how to use these functions.
#googlesheets #googlesheetstips