multi array

  1. X

    INDEX/MATCH within an Array

    Hi 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...
  2. X

    How can I simplify this?

    Hi 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" End If '0 = 20 If...
  3. DDRA Steampunk

    Am I using too many arrays?

    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...
  4. N

    MAx Date multiple criteria

    Hi I am looking for some one data is as below. <colgroup><col><col><col><col><col></colgroup><tbody> DATE Dept BRANCH Transaction Terminal ID 8-Oct-15 TT MCT IN 21666446 8-Oct-15 TT NIZ OUT 21666434 8-Oct-14 TT MCT OUT 21666446 26-Mar-11 TT MCT OUT 21666760 26-Mar-11 TT MCT...
  5. D

    Complex Array Forumla

    I think I need an array formula for the following calculation. <tbody> A B C D E Colour Size Countif1 Countif4 If, Sumproduct(Size, Count) 1 Red 5 1 n/a =5*1 + 6*2 + 4*3 2 Pink 4 1 n/a 3 Blue 2 1 n/a 4 Red 6 2 1 =6*1 + 4*2 5 Red 4 3...

Some videos you may like

This Week's Hot Topics