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

sunil sachdeva 0 Reputation points
2024-12-21T10:24:01.94+00:00

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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,044 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 26,526 Reputation points Microsoft Vendor
    2024-12-23T02:30:53.7266667+00:00

    Hi,

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

    User's image

    User's image

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.