Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SORT (Excel) doesn't work in a column created from a LOOKUP functi
I've created a column of data with each cell's content from the addition of
values in other cells. I have another column using the LOOKUP function for data from specific cells in the column noted above. I want to now SORT this LOOKUP column of data in an ascending manner. The SORT function does not do anything. WHY? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SORT (Excel) doesn't work in a column created from a LOOKUP functi
If your only sorting the column with the lookup function, all of the data
that it refers to is still there and you probably will get the same thing. If you sort a larger range (including the Lookup Value), you should see it sort. "murman" wrote: I've created a column of data with each cell's content from the addition of values in other cells. I have another column using the LOOKUP function for data from specific cells in the column noted above. I want to now SORT this LOOKUP column of data in an ascending manner. The SORT function does not do anything. WHY? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Sort Doesn't Work | Excel Worksheet Functions | |||
How do I get hyperlinks created in Excel to work in a PDF? | Excel Discussion (Misc queries) | |||
getting the column address of an argument to a user defined functi | Excel Programming | |||
How can I make Excel Macros created on PC work on Macintosh? | Excel Worksheet Functions | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) |