https://bugs.documentfoundation.org/show_bug.cgi?id=166731
--- Comment #3 from David Lynch <[email protected]> --- Thank you. Your work-around works only because you know the answer! ... There is only one unique value in my input array. In my use case, the whole point of using UNIQUE is to find out how many unique values in the input array. In all cases except when the values in my input array are identical, I can get the correct answer by counting the number of cells that are not #N/A in an output array from UNIQUE that is the same length are the input array. If I ensure that my input array contains at least 2 different values, with v1 and v2 the smallest, and make the output array the same length as the input, will the output be v1,v2,v3,...,vn,#N/A,#N/A,...,#N/A or are there other situations where I would get results different from the above? I can always ensure there are two different values on imput by including an impossible one: this is fine as a work-around. Is lack of full support for dynamic arrays temporary or longstanding? -- You are receiving this mail because: You are the assignee for the bug.
