How to sort the ladder using correct functions

holiday4ever · #1 07-04-2009, 10:17 PM

I have a league standing worksheet. Some of functions have been a help from someone via this forum, however, where there is a decimal point on the ladder. I am unable to provide a correct standing after it has been sorted. As two of them - their details are not included. Please see attached.

Ancalagon12321 · #2 07-04-2009, 11:21 PM

I have redesigned your spreadsheet. The columns I have added are the ones with blue-shaded headers.

Hopefully it does what you want now.

shg · #3 07-04-2009, 11:32 PM

holiday4ever,

Please take a few minutes to re-read the forum rules, and then amend your thread title accordingly.

Thanks.

holiday4ever · #4 07-05-2009, 02:04 AM

Thanks Ancalagon12321, it works well, however, when I create a new worksheet for the Week6 then copied all cells from previous week then pasted onto Week6 then I entered the scores. The sort area doesn't work, I checked the name define, it is still show for the Week5 instead of Week6. That would mean I have to change the name define manually to look up its current worksheet rather than previous worksheet every time I create a new weekly worksheet? Thanks for your help.

Ancalagon12321 · #5 07-05-2009, 10:42 AM

A 'quick fix' is to do it the other way around:

Make another copy of the week 5 formulas, either by (a) resaving it under a different name or (b) doing Edit > Move or Copy Sheet and making another copy of that sheet within the same workbook.

Having done that, you can just overwrite the data with the week 6 scores.

Alternatively, if you wish to eliminate all named ranges, then simply replace every occurrence of a named range with the corresponding cell reference (but remember it needs to be an absolute cell reference e.g. $A$1:$B$1 rather than A1:B1.)

Welcome to the Excel Forum

Forum Statistics