arrays

  1. L

    Excel Gurus: I need to Solve a Problem with a Sum / Product Calc

    Guys, I Have 2 tables: INCOME X YEAR BY MODEL STORE <tbody> YEAR SR JR 0 1000 500 1 100 80 2 120 140 3 200 180 4 200 180 </tbody> STORE OPENING PLAN <tbody> YEAR STORES 2015 1 2016 3 2017 3 2018 5 2019 1 </tbody> I need a table with te info calculated <tbody> YEAR...
  2. B

    making an x-y array from a 3-column list

    I'm trying to take a list with 3 columns and from it make an x-y array. To illustrate: <tbody> Name Place Year Washington France 1824 Washington Germany 1718 Washington Italy 1702 Washington England 1746 Washington Greece 1725 Adams France 1790 Adams Germany 1733 Adams Italy...
  3. N

    Need URGENT help with populating an array based on Count

    Hi all, I am trying to calculate the Standard Deviation of an array. However, to populate the array, I have the following: <tbody> Count Number 1 Count Number 2 Count Number 3 1 100 2 200 3 300 </tbody> For example, this above means that there are 1 100's, 2 200's, 3 300's. I would...
  4. T

    Arrays/Ranges

    Hi All, I'm looking to find out if/how i can create a VBA array using ranges i have already set using Dim **** As Range, multiplying the cells down the range. the 'base' formula i want to use is: =(( (value in range 1)/3600)*(value in range 2))/(value in range 3*1000) where ranges 1, 2 and 3...
  5. J

    How can I update Excel table values & headings with an array?

    Hello Everyone, Can anyone suggest a clean way of updating an excel table from an array that includes new column headings? I've got a macro that outputs an array of column headings and values to a spreadsheet, and then formats the output as a table. When updating the information using the...
  6. S

    Creating a list of "hashtagged" cells in an array

    Hi! I'm trying to create a list of "hashtagged" cells in array but am running into problems. First let me state that I would prefer to use only Excel formulas to accomplish this goal at this point. I would love to hear how it could be done in VBA, if only to see how much easier it is, but that...
  7. B

    Determining position of last number in array

    Hi there I am trying to figure out a way of determining the position of the last number in an array, where that array includes both spaces and error messages at irregular intervals, and includes multiple values with 3 decimal positions. ie. in a column containing the following values, I would...
  8. T

    Comparing Calculated Value to Array Value

    Hi, I am using excel 2010 and am trying to automate a tedious process that takes me about half an hour. The code below already works but it takes about 5-7mins to run. Basically, I have a list of predefined numbers below that I insert into column A. Then I start at the far right of the table's...
  9. B

    Arrays with COUNTIFS and MATCH

    I have a class 'attendance schedule' tab with multiple parents and multiple classes with a different price per class in the columns with class dates along the top row to track class attendance. On a separate tab I need to calculate what a particular parent owes for a given date range (ie weekly...
  10. J

    Arrays: How to make this formula work to produce info into four columns

    Hello, I am bringing in a list using an array function. I use this function without an array it does the job, but when I actually make it do what it is supposed to do as an array it only works for the first column. Can anyone help to make this work so column b, c, and d produce information...
  11. N

    complex arrays multiple sheets

    Good afternoon, I am struggling to understand arrays. I have read many articles in this forum and in others but I can't seem to get a handle on them. What I am trying to do seems simple. I have 3 sheets, sheet 1 has a week column 4 data points columns, sheet 2 and 3 have charts. I need...
  12. G

    VBA - searching for elements of an array in active sheet

    Hi all, first time posting so apologies if I breach posting etiquette. I'm trying to write a macro which will find members of an array on a sheet, highlight the column and then change the format of the column, what I have at the moment is: Dim datearray(1 To 3) As String datearray(1) =...
  13. C

    Finding the next date in a list

    I am working on an Excel spreadsheet to make sure that everything that has to happen to get a new hire enrolled in benefits happens on time. Our staff are eligible for benefits on the first day of the month after 30 days of employment. (i.e. if the hire date was June 19, 2013 the staff member is...
  14. A

    Problems with Index Array Formula

    Hi, I am trying to use a formula that will look in a really big table for data. The formula looks for 3 things (Market, DOW, TIME) and returns something. Right now This is the formula that I have {=INDEX(FPS,MATCH(A1890&B1890&E1890,MARKET&DOW&TIME,0),16)} And I have two problems: 1. It does not...
  15. A

    Unique Value Array

    Hi all, I have a set of values in a column that has random amounts of duplicates. I need to take this data and remove excess duplicates. Additionally, I then need to, for each unique value in that new column, create 2 duplicates, and assign 3 separate labels in the next column. I started...
  16. D

    Slicing and Dicing CSV files - Involves Arrays and Jagged Arrays

    I am retrieving a CSV file from the net. In this file there are 'x' amount of row data and 7 columns. I only care about the values in the 7th column for each row. I also don't care about the entire first row. A graphical version would be represented something like this, with the values I want...
  17. S

    Subscript out of range error in a sub with arrays

    Hi everyone, I am working on the following code and I am getting without stop this funny error: Subscript out of range. I have no clue how to fix it. It seems I get it each time I try working with arrays... It is pretty upsetting since I get it really almost EACH time. Could someone please...
  18. S

    Filling in an array with data from a range that fall below the average

    I am trying to select those values from a one-dimensional range of data that fall below the average. Also, I am trying to count how many of them there are, and finally, to calculate the variance. This code doesn't seem to be working and I think the problem comes when I populate the array :/...
  19. T

    How to declare a Public Array in Declarations

    I am trying to declale a public array so I can use the dataset throughout the module for quite a few functions. At the moment I am creating the same array for each function and then iterating through the array to calculate the function, so rather than doing this many times I am trying to speed...

Some videos you may like

This Week's Hot Topics

Top