G
gti_jobert
Hi all,
I have created a 2-d array that stored info;
Code
-------------------
j = i
Do
Cells(j, 3).Select
If ActiveCell.Value <> "" Then
maxArray = maxArray + 1
ReDim Preserve Arry(1 To 4, 1 To maxArray)
Arry(1, maxArray) = ActiveCell.Value
Arry(2, maxArray) = ActiveCell.Offset(0, 1).Value
Arry(3, maxArray) = Right(ActiveCell.Offset(0, 2).Value, 6)
Arry(4, maxArray) = Val(ActiveCell.Offset(0, 8).Value / 1000)
End If
-------------------
My question to you is.....if Arry(1, maxArray) and Arry(2, maxArray
and Arry(3, maxArray) are the same then I want to group them and tota
the Arry(4, maxArray) value.
Would the array first have to be sorted first and then grouped? An
advice welcome!
TI
I have created a 2-d array that stored info;
Code
-------------------
j = i
Do
Cells(j, 3).Select
If ActiveCell.Value <> "" Then
maxArray = maxArray + 1
ReDim Preserve Arry(1 To 4, 1 To maxArray)
Arry(1, maxArray) = ActiveCell.Value
Arry(2, maxArray) = ActiveCell.Offset(0, 1).Value
Arry(3, maxArray) = Right(ActiveCell.Offset(0, 2).Value, 6)
Arry(4, maxArray) = Val(ActiveCell.Offset(0, 8).Value / 1000)
End If
-------------------
My question to you is.....if Arry(1, maxArray) and Arry(2, maxArray
and Arry(3, maxArray) are the same then I want to group them and tota
the Arry(4, maxArray) value.
Would the array first have to be sorted first and then grouped? An
advice welcome!
TI