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.