Thanks! If I am understanding correctly, you would like to be able to, for example, take the middle column only of an array with 3 columns. In the video I always start on the right or left side and take everything up to what I want. A possible way around this is to use the =choosecols function as the array for the take function so it would look like =take(choosecols(array, col#,...)row,...). With the =choosecol functions you will be able to specify what certain columns in the array you want it to return.
summary: use take to specify what parts of a table you want to extract into another new table; use drop to specify what part of a table you don't want to extract into another new table allowing the others parts to be incorporated pro: drop and take are dynamic
Thank u for this nice video 📹 👍
Glad you enjoyed the video!
Could you attach the excels you use in your videos to practice with you?
Of Course! Just attached this file, should show up in the description.
I like your video, and btw, any ways to extract certain designated columns from an array?
Thanks! If I am understanding correctly, you would like to be able to, for example, take the middle column only of an array with 3 columns. In the video I always start on the right or left side and take everything up to what I want. A possible way around this is to use the =choosecols function as the array for the take function so it would look like =take(choosecols(array, col#,...)row,...). With the =choosecol functions you will be able to specify what certain columns in the array you want it to return.
summary: use take to specify what parts of a table you want to extract into another new table; use drop to specify what part of a table you don't want to extract into another new table allowing the others parts to be incorporated
pro: drop and take are dynamic
Please check your spelling of countries in your data set before posting. I corrected them in my downloaded version. Thanks for the video.
Too small window used
Should be zoomed because difficult to see
Thanks for the feedback, I will keep this in mind for future videos.
When you said DROP a LIKE, by any chance you wanted to remove one "LIKE"...???? 😀But I TAKE a LIKE here...
Good catch🤣 I'm glad you didn't drop one in that case.