Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't sort data when the key column cells contain formula
I am not able to sort a range of data where the "key" column conains ONLY
formula. While the computer screen displays the numerical result of the formula in each cell of the column, the excel programming apparently can't "read" the cell contents as a number in order to rearrange the rows in ascending or decending order. I'm an experienced excel user, however I've got a sneaking feeling that I'm missing something a beginner could figure out! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I COUNT CELLS WITH DATA BY COLUMN? | Excel Worksheet Functions | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |