array a range

Good Afternoon, I'm trying to assign values (whole number > 0 but <= 5) to each side of a four-sided polygon (sides a, b, c, d) in which the values add up to the same total, such as 12. However, the polygon must be unique regardless of orientation. One way I was visualizing this using Excel...

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

Good Afternoon I've been working on the following macro trying to get all the values in a range for several weeks now. Im at a loss and have had several people help that have me to this point. the code keeps erroring out and Im not certain of what to do next. Explanation of the macro: it takes...

Hello, I'm working on a franken-code from TheSpreadheetGuru's excellent multi-range to multi ppt slide guide at: https://www.thespreadsheetguru.com/blog/2014/6/30/copy-paste-multiple-excel-ranges-to-separate-powerpoint-slides-with-vba My issue is, I need to populate the MyRangeArray with data...

Hello! Unfortunately, I have not worked with VBA arrays so far, and thus I don't know of how to transfer values in a column to an array. I hope someone can help me find a solution for it I have a variable list of URLs in column (("A1:A" & lastRow)) of worksheet "sheet1" wherêby lastRow =...

I'm looking to create a report when we select a week ending date in cell C6 and to have cells b14 though E14 populate with data from the month selected. I'm able to create the index function for YTD in column G but am struggling with formula identifying minimum week within the selected month for...

Hi, I have a two dimensional array. The code checks a row element (column 9). If it contains "Include" then I want the entire array row on one worksheet. If it doesn't contain include then the entire row is placed on another worksheet. It then goes through each row in the array checking...

Hello experienced and talented Excel people. Example. I am working for a company and I have segments, brands and variants. Example: Segment:Coffee, tea, chocolate Brands: coffee--> Nescafe, ground coffee Tea --> green tea, freshly cut leaf Chocolate ---> white, dark, 100 cocoa Variants...

<tbody> Challenge 1: What you know: The employee is in pay grade 3 and rate is $25.30 Challenge: write a formula that looks up the grade, and then returns the value on that range in which $25.30 is nearest to (rounded down) Challenge 2: Write...

So I have some code located on Sheet1(Testing). It allows me to merge certain ranges on that sheet. Here it is: Private Sub Merge() Dim Ary As Variant Dim Rng As Range Dim a As Variant Ary = Array("B23:B24", "B25:B26", "B27:B28", "B29:B30", etc etc etc ......) For...

I am trying to make code that compare value from the list. in column AB there will be list of the values. So if user put values from AB column between F20 and last row of F, 000 value should be in the I column If that values in the AB list and not I column is matching 000 I want to give warning...

Hi, I am hoping someone will be able to help me break these four arrays in bit sizes pieces so my macro will run. The code is below (in R1C1 and nonR1C1 language). The arrays are using whatever sheet name I am on to search another sheet (Vacation Time) for an employees amount of vacation...

Greetings! Long time reader, first time poster. I'm sure there is an answer to this question somewhere but I have spent hours reading trying to find a solution and still cannot find it. Any help will be greatly appreciated! Thanks! Goal: Use a For Loop to loop through an Array of Sheet Names...

Hi, I want to fill Tab pairs, like: [0] = Eng, 2 [1] = De, 3 [2] = PL, 4 [3] = FR, 5 etc... I know how to only add first value. How to 1) add second value and 2) check if the first element is into Tab? (because value like Eng, De....need to be unique into Tab) Dim CostCatTab() As Variant...

Hi guys. I'm new here and i'd like to see if anyone know how to make this work. In a Module i made this function: Function PProduct(arr() As Variant) As Double Dim soma As Double Dim i As Long soma = 1 For i = LBound(arr, 1) To UBound(arr, 1) soma = soma * arr(i, 1)...

Hi, so i'm trying to include an array formula in my workbook (will eventually be automated), all the example i can find have data starting in a1, my data doesn't and i can't get the formula to work as it should. It's fine if i put my data into A1 and then eneter the formula, but i can't work out...

I'd like to be able to efficiently read all of the formatted values of a range of cells into an array. When I say formatted values, I mean the values as they are shown on the screen. Range.Value and Range.Value2 can efficiently retrieve the values into an array. Range.Text seems to work only...

<tbody> A B C D E 1 Type Black White Grey ANSWER 2 single 1 x 5m Black 3 multi 1 x 5ml 1 x 5ml 1 x 5 ml multi 4 single 1 x ml Grey 5 twin 2 x 5ml White </tbody> I need to find the answer to E2:E5 by If type = multi then Answer =multi else ANSWER is the value of...

I have a list of football results <tbody> Stoke 0 1 Aston Villa 1 0 West Brom 2 2 Sunderland 2 2 West Ham 0 1 Tottenham 1 0 Arsenal 2 1 Crystal Palace 1 2 Man Utd 1 2 Swansea 2 1 Leicester 2 2 These results continue and the team...

Hi All, I am dealing with a document similar to a very large Gantt chart with Dates at the top of each column and non zero values in the grid below recording which projects are worked on. I am looking for a formula that can read the corresponding date to the first and last entry within each...