multi array

I'm trying to replace a dropdown menu, whith a cell. The user is going to input the real distance in this cell. As it's works now, the user select the nearest "visible" distant (there can be several selectables but the one whith the best / longest option is visible) So this works like this...

Hello, I am a novice to VBA, but I'm getting there. I am trying to build a program, and one of its aspect is to use two-dimensional arrays. One of the functions get directories, where it fetches an array of folder directories, an array of spreadsheet directories, and then stores both of those...

Hello, I have this code involving adding 3 bits of data to 3 multi dimensional arrays - running some processes and then printing back from one array Problem I am having is writing the calculated result back to the array Please have a look and tell me where I am wrong.. I am not posting the...

Hi everyone, I have a bit of convoluted question regarding multiplying dynamic amounts based on date and time conditions. I have tried a fair few different formulas including sumproduct, vlookup and ifs - but nothing gives the right answer. This is quite a large sheet so I have only copied...

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

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

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

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