
Channel: MrExcel.com
Category: Howto & Style
Tags: unique of a rectangular range in excelmrexcelusing tocol function in excelmicrosoft excelbill jelengetting a unique list in excelexcelnew in exceltocol function in excelmicrosoft 365 excelunique function in excelexcel formulassort function in excel
Description: 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.











![video thumbnail for: A Day at the Beach 1928 - Odessa in 1920s [4K 60fps]](https://i.ytimg.com/vi/HVR529qh7nQ/mqdefault.jpg)

![video thumbnail for: A Day at the Beach 1928 - Biarritz France 1920s | AI Enhanced [60 fps 4k]](https://i.ytimg.com/vi/WJNjKvCP8UY/mqdefault.jpg)

![video thumbnail for: A Walk in the Park - c.1900 | Bois de Boulogne Paris - AI Enhanced [4k 60 fps]](https://i.ytimg.com/vi/4YBbcXKguzA/mqdefault.jpg)

![video thumbnail for: A Day at the Beach - c.1921 | AI Enhanced Film [60 fps 4k]](https://i.ytimg.com/vi/y-6W9xNTe2A/mqdefault.jpg)