Is it possible to sort this table assending and keep the name associated with the points?
In addition renumber the position according to the sort ranking.
Would it then be possible to reorder the sort every time the points change as they are read in from another table?
iMac, OS X Mavericks (10.9)
Can I just drag the first cell down and so on or will I need to copy & paste?
you can drag to fill
Something is amiss I selected everythin in the tabe and sorted asscending. Her are before and after screen shots
Before
After
DT,
You will have to be more specific. What column did you sort, on which table?
Jerry
What formula is in column C?
There is no formula in C. it is looking at the Pool Standis table
double click cell C2 and copy the formula out and paste here, please
I neglected to put your original code in C only because your previous message about B made no reference to C and I forgot it. I will do that and try again. When I sort how many columns do I need to select?
enter the formula in cell C2, then fill down, then sort on column C
It does not like this
=INDIRECT("'TABLE 2-1'::T"&B2)
What is the error? click the triangle in the cell (assuming there is one)
Is "TABLE 2-1" the name of the table? It should be the name of the table where the stats are located (the big table I think is named "2013 Pool Standings") THIS NAME MUST MATCH EXACTLY
The formula should be "=INDIRECT("'2013 Pool Standings'::T"&B2)"
I had a typo in my original post. I am sorry about that.
Where will the pts display after the sort? Do the pts in the source table 2013 Pool Standings need to be on the smae row as the individuals name?
they will stay in the same row as the name-- that is the whole point of this, right?
Sorting?
