How to get the Unique list of items appearing in a rectangular range. This solution uses the new TOCOL function released on March 16, 2022 to Microsoft 365 Office Insiders.
Transcript of the video:
Getting the unique of a rectangular range using the new TOCOL function.
Done this twice on the podcast before: 9 minutes, 3 minutes.
So simple now to get the unique list of items over there, we're going to do with the UNIQUE of TOCOL.
A brand new function released in March 2022. That's it, we are done.
If you want it sorted, add a SORT - wap the whole thing.
There you go. Well, that's 600 seconds down to 30 seconds. I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Done this twice on the podcast before: 9 minutes, 3 minutes.
So simple now to get the unique list of items over there, we're going to do with the UNIQUE of TOCOL.
A brand new function released in March 2022. That's it, we are done.
If you want it sorted, add a SORT - wap the whole thing.
There you go. Well, that's 600 seconds down to 30 seconds. I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
