In Excel 2000, I have a column of data containing the HLOOKUP function.
In order to plot a scatter graph, I want to sort the data in this column
based on the values returned by the HLOOKUP function.
The sort appears entirely random!
The results are not in value order or even in alphabetic order.
How can I force the sort to use values without copying them to another column.