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.
Last edited by holiday4ever; 07-05-2009 at 02:29 AM.
I have redesigned your spreadsheet. The columns I have added are the ones with blue-shaded headers.
Hopefully it does what you want now.
holiday4ever,
Please take a few minutes to re-read the forum rules, and then amend your thread title accordingly.
Thanks.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
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.
Last edited by holiday4ever; 07-05-2009 at 02:28 AM. Reason: Change of Thread Title
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.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks