array

I have a list of zip codes in a verticle column (A32:A200) on a sheet Named "Formulas". I have an image named "Bolt" in cell C4 on a sheet, named "New Job Log". Also on that New Job Log sheet, I have two non adjacent columns. On the left, starting at C5 is an empty column of cells. On the...

Hi, I am looking for one Excel formula to put in cell A1 that counts all AD values on workdays (not weekends nor holiday 2-01) from the beginning to the end of the month. The dates (see image) are in row 2, the values in row 3. I am struggling with this.

Hello and thanks for reading. I am missing something simple here on a conditional loop. I am first checking to see if a textbox on a userform has a number in it. If it does not, i am looping through the 5 sheets that may have the number in cell P14. Whenever i find the number i want to change...

Can anyone help me with the following? I have a spreadsheet containing data having IP addresses in which I need to create a output text file. A sample input file would look like this owner active group address exp a 1 gray 10.10.10.10 1/1/2023 b 1 blue 10.10.10.12-10.10.10.15 1/1/2023...

I have a 2D-Array and I want to look up for values in the column. arrDestination(0, i) = Name(i) (asdfg, csda, asdfg,zzz) arrDestination(1, i) = Values(i) (100, 50, 100, 60) My 2D Arrays contains the names and values. If my arrDestination Array match with Column A then I want to insert the...

Hello, i am trying to run a macro that print an array of sheets in the description. However i have a macro that hides certain sheets pending other options and when i do the printout option it comes up with an error if one of the ****s has been hidden. The sheets need to remain hidden depending...

Hi, I am trying to generate headers for a table. I decided to create a function just to generate header for my table. and to decide which row the header will go to my idea is to put the first element of my array(array that will be pass into the function)as the row number. following is my...

Hi, I have the following code which creates an array "Ary" with string elements from a table column that match value "x" from another column in this table. I would like to have cell E6 display a randomly picked string element from this array "Ary". How would I have to alter the VBA code? Sub...

How can I open file1 from list1, copy sheet1 from file1, paste it on sheetname1 from list2, close file1 and go to the next.... for any amount of files, variable until the named range is done. Sheets("Data").Range("E2:E30") is list1, list of files {C:\Documents\robertheinz.xlsx...

Hello, Column A is filled with string values. Column B is sometimes filled with the value "x". I would like to write VBA code that returns all the string values from column A into an array if they match the "x" value from column B. Anyone knows how to do this? Thanks

Hello, I got a macro button which adds month sheets for a specific year that is entered in an inputbox. The following code unsuccessfully attempts to fill all working days with a pink colour if they match a range of cells that represent the holidays (and include blank cells). Is there a way to...

I am working on putting a template together for my company and ran into a problem with having two dropdown lists. The goal is to have that ever is selected in list 1 to populate only a set list of items for list 2. The spreadsheet attached i am working in column 'H' & 'I'. the code form column...

Hello all - I have a question, please: Col A has values. Col B checks a condition and returns true or not ("Y"). If Col B returns TRUE, Col C stores Col A's value. Col D repeats the stored value so that: Col E can check Col D against a different condition, and returns TRUE or not. This...

Hi, I'm trying to do a formula to show the totals of each group based on different criteria that could possibly change. For example, with the below data I'd want in a separate spreadsheet showing the two subtotals (342.88, 138.28 etc) but these subtotals are based on column B(4141, 4142 etc)...

I have an array that I need to load based on two different filters and then copy data to a new sheet. I have used code from a prior post "Extract some rows to a new sorted list" but need to add an extra filter. I also am getting an error 2015 on the aRws which is not allowing the array to load...

Hi Folks, I am trying to take a wide format array and using vba convert it to a tall skinny format. Currently my xl2bb is blocked so I pasted an example table at the bottom of this. Example wide format on left, desired format on right) My starting code is here. I've tried a few different...

I am trying to write a macro to load an array until a certain value is found. Right now, the user will enter the current month commission, i.e. March. I then need the array to only load the value in column C for February and January, (60 days) then stop so I can execute other code. The array...

MAKECOMBO Function: Returns combination of two arrays =LAMBDA(array1,array2,LET(a,array1,b,array2,La,COUNTA(a),Lb,COUNTA(b),MAKEARRAY(La*Lb,2,LAMBDA(r,c,IF(c=1,INDEX(a,INT((r-1)/Lb)+1),INDEX(b,MOD(r-1,Lb)+1)))))) Here is example (attached image) This is my first lambda function posted here...

Hi, I need to create a 100 × 100 array, which has ones in its subdiagonal elements and zeros in other elements. I also have to use the For next statement. I cant get it right after several tries. This is where I am for now. Could you please help me? Thanks a lot

I don't have access to VSTACK yet, so I am using a workaround to stack many dynamic arrays on top of each other in a list. To do this, my helper array formula is as follows...