find the highest number in a string of numbers

[Jerk24]

I have asked two questions today both answered. sooooo

is it possible to find the highest number is a string of numbers, in different cells:

cell c3 = 12+13+14
cell d3 = 20+21+22
cell e3 = 12+20+20

there are alot more and was wondering if there was a way for me to just add everything and not worry about the "HIGH Game"? the formula i have =LARGE(C3:K3,1) Which brings the highest number, not the single highest number

<tbody>
</tbody><colgroup><col></colgroup>

 

[Jerk24]

When Someone misses a week, the abs is manually input by me to represent Absent. The code is working fine, but when it detects anything other than a number it will return the "#Name?" error. below will show a how the code works and then how it returns the error. is there a way to tell the code to only look at numbers?

Wk 1

Wk 2

Wk 3

Wk 4

Wk 5

Wk 6

Wk 7

Wk 8

Wk 9

ABS

47

54

64

Wk 10

Wk 11

Wk 12

Wk 13

Wk 14

Wk 15

Wk 16

Wk 17

Wk 18

# Games

Points

AVG

Hi Gm

Hi Trp

Turks

Lst Wk

9

165

18.33

#NAME?

64

2

64

Wk 1

Wk 2

Wk 3

Wk 4

Wk 5

Wk 6

Wk 7

Wk 8

Wk 9

61

52

69

74

Wk 10

Wk 11

Wk 12

Wk 13

Wk 14

Wk 15

Wk 16

Wk 17

Wk 18

# Games

Points

AVG

Hi Gm

Hi Trp

Turks

Lst Wk

12

256

21.33

27

74

2

74

Wk 1

Wk 2

Wk 3

Wk 4

Wk 5

Wk 6

Wk 7

Wk 8

Wk 9

37

47

35

41

Wk 10

Wk 11

Wk 12

Wk 13

Wk 14

Wk 15

Wk 16

Wk 17

Wk 18

# Games

Points

AVG

Hi Gm

Hi Trp

Turks

Lst Wk

12

160

13.33

21

47

0

41

Wk 1

Wk 2

Wk 3

Wk 4

Wk 5

Wk 6

Wk 7

Wk 8

Wk 9

34

53

26

43

Wk 10

Wk 11

Wk 12

Wk 13

Wk 14

Wk 15

Wk 16

Wk 17

Wk 18

# Games

Points

AVG

Hi Gm

Hi Trp

Turks

Lst Wk

12

156

13.00

20

53

0

43

Wk 1

Wk 2

Wk 3

Wk 4

Wk 5

Wk 6

Wk 7

Wk 8

Wk 9

38

ABS

34

ABS

Wk 10

Wk 11

Wk 12

Wk 13

Wk 14

Wk 15

Wk 16

Wk 17

Wk 18

# Games

Points

AVG

Hi Gm

Hi Trp

Turks

Lst Wk

6

72

12.00

#NAME?

38

0

ABS

<tbody>
</tbody><colgroup><col span="3"><col><col span="5"><col><col><col><col><col><col><col></colgroup>

 

[Rick Rothstein]

Thank you for the table... that clarified everything for me. My previously posted code (Message #17) did not know about the "ABS" entries (you hadn't mentioned them before), so when it got included in the text string my code formed to feed into the MAX function, VB "choked" when it tried to process it along with other real numbers. Here is that previously posted code, modified to ignore the "ABS" entries (all I had to do to fix it was add the red highligted part to my previous code)...

Private Sub Worksheet_Change(ByVal Target As Range)
  Dim X As Long, Pluses As String, Numbers As Variant, Rng As Range
  Const SetOffsets As Long = 4
  For X = 0 To 47
    If Not Intersect(Target, Range("C3:K3,C5:K5").Offset(X * SetOffsets)) Is Nothing Then
      Set Rng = Range("C3:K3,C5:K5").Offset(X * SetOffsets)
      GoTo Continue
    End If
  Next
  Exit Sub
Continue:
  With WorksheetFunction
    Pluses = .Trim(Join(.Index(Rng.Areas(1).Formula, 1, 0), " ")) & _
             "+" & .Trim(Join(.Index(Rng.Areas(2).Formula, 1, 0), " "))
    Pluses = Replace(.Trim(Replace(Replace(Pluses, "+", " "), "=", " ")), "ABS", 0, , , vbTextCompare)
    Cells(Rng(1).Row + 2, "O").Value = Evaluate("MAX(" & Replace(Pluses, " ", ",") & ")")
  End With
End Sub

 

[Jerk24]

Thank you, I copied the code to the sheet and retyped all of the cells containing ABS (you mentioned before that I needed to update the cells for the event to work) and nothing happened. Is there another step I am missing?

 

[Jerk24]

Nevermind. I saved the XLSM, and re-opened and now it is working when I re-input the cell values,

thanks again.

 

[Jerk24]

Rick and hiker

I posted (http://www.mrexcel.com/forum/excel-questions/744791-pull-highest-score-range.html) yesterday and it is very similar to this -- can you take a look and see if you can help-- Thanks in advance.