Stopping formulas from changing when sorted

L

Lehane

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a template that I can reproduce every month by keying ininformation from SAP 8
Table Preferred width is changed when pasting 1
Sorting data, but not the formulae 1
Only Calculating Numerics 5
Look up one value and return multiple corresponding values 2
Sort two tables of data 5
Multiple Challenging Excel needs.... 0
Keep original cell formatting when using transpose array formula 1

Top