Function help!
 

If I have a list of nations with values assigned to them based on recent
sport results, is there any way I can add the value I wish to assign
from the results that I have on my second page? For example, Spain may
have played 5 games and I want to use macros to add the value of their
results from page 2 on to page 1. I just don't know how to assign the
value each time a team name appears.
Any help would be of great assistance,

Cheers,

Phil


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=548544

Function help!
 

Hi Phil,

I think you should be able to do this without the need for Macros using
worksheet functions like Sumif. for example if you use
=SUMIF(Sheet2!A1:A50,Sheet1!A1,Sheet2!B1:B50) this will sum the value
in column B on sheet 2 where the value in column A equals that of sheet
1 cell A1. So if cell A1 (sheet1) equals spain, anytime on sheet2 where
spain appears between the ranges of A1 to A50 the values in B1 to B50
will be added.

If I have misunderstood or not explained well enough then post back.

Cheers,

James


phil2006 wrote:
If I have a list of nations with values assigned to them based on recent
sport results, is there any way I can add the value I wish to assign
from the results that I have on my second page? For example, Spain may
have played 5 games and I want to use macros to add the value of their
results from page 2 on to page 1. I just don't know how to assign the
value each time a team name appears.
Any help would be of great assistance,

Cheers,

Phil


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=548544

Function help!
 

Thanks! That was helpful! I'm still not entirely sure if it will wor
though. I have to use macros because each result is given a value, thi
value then has to displace the oldest result and then the team has a ne
rating which can then be updated as the next result is reached. Thu
rather than merely adding all of the results they will be weighte
based on the last few games. So what I need is some formula that wil
transpose say, Spain's most recent result onto sheet one, and if Spai
then have another result it shall replace this one as the most recent
I don't think I'm explaining this too clearly but any help would b
very much appreciated!
Thank

--
phil200
-----------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...fo&userid=3509
View this thread: http://www.excelforum.com/showthread.php?threadid=54854

Function help!
 

Hi Phil,

No I am not entirely sure what you are trying to do. So keeping to the
example of spain you are tracking there recent wins on sheet two and
then formulating a league table on sheet 1? But you only want there
recent wins? So say Spain win 2-1, do they get a higher score than if
they win 3-1 and does that add up to what there value is or is it there
latest game(s) that determines there score? There are functions to pick
up multiple sumif's etc. or the maximum three results etc.

Cheers,

James

phil2006 wrote:
Thanks! That was helpful! I'm still not entirely sure if it will work
though. I have to use macros because each result is given a value, this
value then has to displace the oldest result and then the team has a new
rating which can then be updated as the next result is reached. Thus
rather than merely adding all of the results they will be weighted
based on the last few games. So what I need is some formula that will
transpose say, Spain's most recent result onto sheet one, and if Spain
then have another result it shall replace this one as the most recent!
I don't think I'm explaining this too clearly but any help would be
very much appreciated!
Thanks


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=548544