score1

Hello I have data to analyse game result as follows. Every team has to play twice with the same opponent yielding Score1 and Score2. I have to add total score of each player on a table 2 shown below. The main problem is the number of team will be changing. If a team is added then every team...

I found this script and i now wonder how to make it work in more than one row. i tried to add Range("A1:A10"). but it gives me a run time-error 13 . Hope you can help. Sub test() Dim score1 As Integer, score2 As Integer, result As String score1 = Range("A1").Value score2 = Range("B1").Value...

Ive been having troubles looping mi script into the entire column. it looks like this Sub if_veracruz() Dim score1 As Integer, score2 As Integer, result As String score1 = Range("F2").Select score2 = Range("h2").Select If score1 = 30 And score2 <= 5 Or score2 = 8...

I am trying to get his excel formula to work. This is an API to Marketo to do Excel calculations. The calculation I am trying to do is: =INDEX({ “Score1″, “Score2″, “Score3″, “Score4″, “Score5″}, MATCH( MAX({ {{lead.Score1:default=0}}, {{lead.Score2:default=0}}, {{lead.Score3:default=0}}...