| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sorting on cells containing HLOOKUP
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting master sheet messes up cells in other sheets linked to it | Excel Worksheet Functions | |||
| identically size merged cells for sorting rows | Excel Discussion (Misc queries) | |||
| sorting cells according to all cells in column A | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
