| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stopping formulas from changing when sorted
I'm trying to link two tables, adding two cells from one table to a cell in
another table, however I want to sort both tables (they're for motorsports results). My formula is currently =('Australia, Melbourne' 'Fernando Alonso;')+('Australia, Melbourne' 'Lewis Hamilton;') but whenever it's sorted the 'Fernando Alonso;' changes to 'Heikki Kovalainen;' How can I stop it from changing when I sort the tables? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic Changing of Formulas | Excel Discussion (Misc queries) | |||
| stopping the date from changing in Excel (and Google Spreadsheets) | New Users to Excel | |||
| Solution to stopping IE opening excel workbooks without changing windows settings | Excel Discussion (Misc queries) | |||
| Do formulas in a table translate when sorted? | Excel Worksheet Functions | |||
| Changing values but not formulas | Excel Worksheet Functions | |||
Threaded Mode
