|
Dynamic sorting functions
If you want to dynamically sort the results of a calculation or the output of an array function such as LISTDISTINCTS you can use the 6 dynamic sorting functions with case-sensitive and index sort options. 4 of these functions provide the same sort sequence as the Excel SORT command and can be used to prepare the input for all the LOOKUP functions.
VSORTC - Dynamic multi-column sort of a vertical range/array
VSORTC.INDEX - Like VSORTC but returns a single column of indexes to the data
VSORTB - Like VSORTC but uses a fast binary comparison
VSORTB.INDEX - Like VSORTC.INDEX but uses a fast binary comparison
Case.VSORTC - Case-sensitive VSORTC
Case.VSORTC.INDEX - Case-sensitive VSORTC.INDEX
|
