#MS365 #Advanced_Excel
UNIQUE function is one of the dynamic array functions of MS365 which return the list of unique data from a list or range. This is a dynamic function and is automatically updated.
For older versions of Excel , a workaround has been suggested. Do go through that.