Unique and sort function not woring in my excel 2019 home and student

Question

Ive microsoft 365 and home and student 2019. unique and sort functions are not working in that.Screenshot 2024-12-21 155052.png

Answer 1

Hi,

The UNIQUE and SORT functions are not available in Excel 2019:

https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e

https://support.microsoft.com/en-us/office/sort-function-22f63bd0-ccc8-492f-953d-c20e8e44b86c

As a workaround you can use these functions in Excel for Web.

Hope the information is helpful.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.