I need an efficient function to find unique set from a number of numeric arrays.
For example:
A1 = {1; 1; 1; 1};
B1 = {1; 2; 1; 2};
C1 = {1; 2; 1; 1};
Expected result would be:
E1 = {1, 1, 1; 1, 2, 2; 1, 2, 1}
Input arrays are column arrays (same length) which values are numeric (Double-type).
This is to be called thousands of times, so I'm wondering if we can do this more efficiently.
Normally I would do: =VALUE(TEXTSPLIT(TEXTJOIN(";",FALSE,UNIQUE(A1#&","&B1#&","&C1#)),",",";"))
Is there another way to achieve this more efficiently, e.g. without text-numeric conversion and text join/split?
For example:
A1 = {1; 1; 1; 1};
B1 = {1; 2; 1; 2};
C1 = {1; 2; 1; 1};
Expected result would be:
E1 = {1, 1, 1; 1, 2, 2; 1, 2, 1}
Input arrays are column arrays (same length) which values are numeric (Double-type).
This is to be called thousands of times, so I'm wondering if we can do this more efficiently.
Normally I would do: =VALUE(TEXTSPLIT(TEXTJOIN(";",FALSE,UNIQUE(A1#&","&B1#&","&C1#)),",",";"))
Is there another way to achieve this more efficiently, e.g. without text-numeric conversion and text join/split?