Mar 07 2022 02:25 PM
I'm trying to run a sort on a spreadsheet. It won't do it because it's saying something like it cannot run the support because there's a array.
I don't remember setting up an array.
How do I get rid of the array?
Operating system Windows, Excel from Office 365.
Thanks!
Mar 07 2022 02:42 PM
You could help us help you by describing what you DO remember, what you DID do. In particular, I'm wondering if you might have used the UNIQUE or FILTER functions. Those functions are called "Dynamic Array functions" and inherently establish an array as their output. If you used one of those, you could sort the resulting array by adding the SORT function to it.
But if that's not what you've done, perhaps you could describe the situation a bit more completely. What is the nature of the data that you're seeking to sort, how was it created, etc...
Mar 07 2022 03:06 PM
Mar 07 2022 08:04 PM