00:00Should I develop a unique function as an add-on to support older Excel version like Excel 2019, 2016, 2013,
00:07and et cetera, and et cetera?
00:08That was the community poll I conducted over the span of three days.
00:11The finding from that poll indicates that I should proceed with it.
00:15All righty then, let's move forward with it.
00:17The first thing you're going to have to do on your spreadsheet is press alternate F11 to open a VBA
00:21editor.
00:22On your modules, you're going to right-click on your modules, insert, module, and you're going to paste this VBA
00:27script.
00:27If you like a copy of this VBA script, leave the request on the comment section, and I'll show you
00:31how you can get it.
00:32Next thing you do is press Ctrl S to save and close the VBA editor.
00:36And let's do a quick test and try out our unique function.
00:39And just like the Excel's unique function, it accepts the first argument as a dataset array.
00:44And just as a test, I'll use the Excel's unique function to compare the outcome.
00:48The result is absolutely identical.
Comments