00:00just a quick public service announcement having an older version of excel doesn't necessarily mean
00:03that you can't access function exclusively to newer versions take for instance the choose row
00:09function available only in newer excel version if you require its functionality but have an older
00:15excel version here's how you can still make use of it press alt f11 to launch a vba editor and
00:21scroll all the way down until you see modules right click on modules here insert modules in this
00:26module you're gonna paste this vba function here if you need a copy of this vba please leave a
00:32request on the comment section and i'll show you how you can get it press ctrl s to save your
00:37vba and
00:37close the vba editor now to test and compare i'll create an excel choose row function to display row
00:432 4 and 6 of this data set adjacent to it i'll employ my choose row function coded in vba
00:50with identical
00:51argument as you can see the results are exactly the same between excel's choose row and my vba choose row
00:58function
Comments