I have a large report that I am pulling into a multi-dimensional array. I'm then using a function to remove dupes and then running various loops summarizing the data from the main array, but I am stuck on one point. I can't find a way to use INDEX/MATCH functions within arrays.
ie if I was...
I've managed to come up with this code:
Dim v, i As Long
v = Range("D2:Q" & Range("D" & Rows.Count).End(xlUp).Row).Value
For i = 1 To UBound(v)
'N Is 20
If Left(v(i, 3), 1) = "N" Then
v(i, 2) = "20"
'0 = 20
Solved right after initial post (by experimenting). :stickouttounge:
I need to autohide a crazy huge number of rows in one sheet, it currently has 9 sub tables (see Sample 2), and may need 11. Page not included because it's about 10 paper sheets long. Trying to get all arrays on one toggle...
Hi I am looking for some one help..my data is as below.
I think I need an array formula for the following calculation.
If, Sumproduct(Size, Count)
=5*1 + 6*2 + 4*3
=6*1 + 4*2