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

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

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

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

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

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