ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Stopping formulas from changing when sorted (https://www.excelbanter.com/excel-worksheet-functions/130639-stopping-formulas-changing-when-sorted.html)

Lehane

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?


All times are GMT +1. The time now is 02:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com