00:00Listen, have you attempted to utilize choose column function in Excel only to encounter a value error?
00:05This is because the choose column function is exclusively accessible on Microsoft 365 or Excel 2021 or later versions.
00:13How do you get around that?
00:15Well, I've got a solution for you using VBA, and here's how you do it.
00:19Right-click on your worksheet, view code.
00:21When this comes up, right-click on module, and you're going to say insert module,
00:25and you're going to paste this VBA script here.
00:27If you need a copy of this VBA script, please leave a request on the comment section,
00:30and I'll direct you on how you can get it.
00:32After that, press Ctrl-S, save, and close your VBA editor.
00:35To test and compare, I'll create the Excel's choose column function to display column 2 and 4 of this data
00:41set.
00:42Adjacent to it, I'll employ my choose column function coded in VBA with identical argument.
00:47As you can see, the results are exactly the same.
Comments