Forum Discussion
UNIQUE Function instability
Using Excel 365, I built a spreadsheet that included the UNIQUE function for the first time last night. It saved with no problem, but when i opened it this morning, the spreadsheet would only hang wi...
It looks like a bug, hope one-time one. Never seen that in my practice. In any case I'd recommend to Send a Frown form within Excel, Microsoft monitors them.
=UNIQUE(S9:S1342) converted to the set of array formulas you may reproduce manually - enter the formula in any cell with Ctrl+Shift+Enter, it returns only one value. Drag it down, formula returns one by one values. Perhaps that Excel done on Repair and that's not specific of UNIQUE formula, just dynamic array calculations were transformed.