Need help sorting linked cells.

  • Thread starter Thread starter NailBombJoe
  • Start date Start date
N

NailBombJoe

I have a column of cells that are linked to cells from different place
in the same spreadsheet. These cells contain golf scores. I want t
be able to sort the column of linked cells in ascending order. How ca
I do this
 
If your formulas are like:
=sheet2!b33
I think you'll have trouble.

You may want to try to put a key value in each row (golfer's name???) and then
use a different formula to retrieve the value:

=vlookup(a33,sheet2!a:b,2,false)

Then sort.
 
You must log in or register to reply here.

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

RANKING alters when data is filtered 4
How to highlight the lowest valued cell in a column in Excel 2003 2
How to sort names in alphabetical ascending order? 7
Average cells based on column header 6
Merging Cells and Sorting 1
Assign points based on two conditions 1
Sort when I have blank cells 1
sort a table that contains both numbers and blank cells 1

Back
Top