Dec 27 2021 04:21 AM
When using the following functions (sort and unique) in Excel (2016) I suddenly see the following error =_xlfn._xlws.SORT(_xlfn.UNIQUE(C4:C585)).
When I was working in this excel file last week, both functions worked fine. Today I was importing text files and suddenly these functions were not visible anymore. Could someone provide help?
Dec 27 2021 04:36 AM
The functions you mention (SORT and UNIQUE) are only available using Microsoft 365 or Excel 2021. The mystery is how the functions ever worked for you.