Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
league table problem
hi, i have created a league table for a project on the world cup for work. i want the table to update as the reults from the games are entered elsewhere but when i do all the formulas get mixed up(i think they don't move as the table data sorts) is there any way around this. many thanks Mark -- boufant ------------------------------------------------------------------------ boufant's Profile: http://www.excelforum.com/member.php...o&userid=24725 View this thread: http://www.excelforum.com/showthread...hreadid=529395 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
league table problem
I think we would need an explanation of the data layout and see the
formulae. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "boufant" wrote in message ... hi, i have created a league table for a project on the world cup for work. i want the table to update as the reults from the games are entered elsewhere but when i do all the formulas get mixed up(i think they don't move as the table data sorts) is there any way around this. many thanks Mark -- boufant ------------------------------------------------------------------------ boufant's Profile: http://www.excelforum.com/member.php...o&userid=24725 View this thread: http://www.excelforum.com/showthread...hreadid=529395 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
league table problem
hi bob, how do i do that. i'm a bit of a newbie here. cheers Mark. -- boufant ------------------------------------------------------------------------ boufant's Profile: http://www.excelforum.com/member.php...o&userid=24725 View this thread: http://www.excelforum.com/showthread...hreadid=529395 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
league table problem
show the data, best to use some sort of cell delimiter such as
A1 | B1 | C1 | etc Spurs| 1 | Arsenal| 0 etc and state what formulae you are using, where. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "boufant" wrote in message ... hi bob, how do i do that. i'm a bit of a newbie here. cheers Mark. -- boufant ------------------------------------------------------------------------ boufant's Profile: http://www.excelforum.com/member.php...o&userid=24725 View this thread: http://www.excelforum.com/showthread...hreadid=529395 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
league table problem
hi bob, would it be easier to email my project to you. cheers Mark -- boufant ------------------------------------------------------------------------ boufant's Profile: http://www.excelforum.com/member.php...o&userid=24725 View this thread: http://www.excelforum.com/showthread...hreadid=529395 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
league table problem
Okay, no promises, but I will take a look.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "boufant" wrote in message ... hi bob, would it be easier to email my project to you. cheers Mark -- boufant ------------------------------------------------------------------------ boufant's Profile: http://www.excelforum.com/member.php...o&userid=24725 View this thread: http://www.excelforum.com/showthread...hreadid=529395 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table Refresh problem | Excel Discussion (Misc queries) | |||
League Table | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Problem with linked Excel table in a word Document | Excel Discussion (Misc queries) |