column A is labels
column B is values
and I want output a sorted list without macros.
This is pretty easy if there are no duplicate values, but
I've been using
Column C. rank(B:B,switch)+row()/70000 to eliminate
duplicates
Column D. rank(C:C,switch)
Column E. match(row(1:1),C:C,0)
Column F. indirect("A"&[row from column E])
Column G. indirect("B"&[row from column E])
So I have 3 intermediate columns between input and output
Besides the obvious copypastesort and without macros,
is there a quicker way to do this?