LinkBack URL
About LinkBacks
how to insert current position in the box marked current position and this to change each week as games played etc (see picture)
please keep it as simple as possible - thank you all for your time and help
Current.PNG
how to insert current position in the box marked current position and this to change each week as games played etc (see picture)
please keep it as simple as possible - thank you all for your time and help
Current.PNG
Last edited by Patcheen; 02-28-2015 at 11:59 AM.
Hello
Not getting what you need exactly...
As far I have understood you need to lookup for the current week number and get the corresponding value...
This may help
=VLOOKUP(WEEKNUM(TODAY()),A:B,2,FALSE)
Sorry if this is not what you need...
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
thank u for your help maybe if i explain a bit better -
on b7 which shows 13 is because when all games finished in the league this is where they finished as results change game by game e.g b8 they were 18 and b9 is 19 etc etc the blue column is only reference and has no baring on results. so as you b33 is 12 i need this to be inserted in b44 and when they play next week when they either go up or down the table example if they climb to 11th place then b44 will change to 11 sorry if sound confusing
Use for best:
Formula:
Please Login or Register to view this content.
and for worse:
Formula:Please Login or Register to view this content.
Never use Merged Cells in Excel
ive that done for best and worst as you can see but how do i do it for latest position as it is currently 12
Ok I got your point
Use this array formula
=INDEX(A1:A44,MIN(IF(A10:A44="",ROW(A10:A44)-1,9^9)))
This is an array formula so after pasting this formula in the cell press ctrl+shift+enter instead of just enter as we usually do...by doing so you will get two curly braces like {} around the formula
Hope this helps
For current use:
Formula:Please Login or Register to view this content.
Sorry slight mistake
just change it to this one
=INDEX(A1:A44,MIN(IF(A7:A44="",ROW(A7:A44)-1,9^9)))
Hahahaa
Much Better option by Zbor....
Thanks to you all for your help this is now completed thanks again ye are brilliant
sorry i dont know how to close this thread as solved
Just select Thread Tools from the menu link above and mark this thread as SOLVED.
Thank you guys for all your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks