| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sort data without messing up cel linked equations?
I have a Excel sheet with various data that I want to sort by A-Z, the
problem is I have equations the do not sort correctly. Example: Befo A1 - Mouse B1 - (=A3) A2 - Dog B2 - *** A3 - Cat B3 - (=A2) After A-Z Sort: A1 - Cat B1 - (#REF) A2 - Dog B2 - *** A3 - Mouse B3 - 0 Please help. This should be simple, but I just can't make it work. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I data sort multiple sheets in Excel that are linked with i | Excel Worksheet Functions | |||
| Displaying linked data in excel 2007 when linked file is not avail | Excel Discussion (Misc queries) | |||
| Sort without messing up formulas | Excel Discussion (Misc queries) | |||
| Sort & add columns without messing up formulas | Excel Worksheet Functions | |||
| sort 2 or more rows of cells linked to one row of data | Excel Worksheet Functions | |||
Threaded Mode
