Forum Discussion
LucFlynth
Dec 27, 2021Copper Contributor
Excel functions
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, ...
PeterBartholomew1
Dec 27, 2021Silver Contributor
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.