vector

  1. M

    EXCEL VBA for Mass Balance

    Good day community, Would you help to write a vba code for following Mass balance & Data ReconciliationThe data reconciliation problem is solved using the method of Lagrange Multipliers. Let’s denote the vector of measurements as M, whose elements are the measurements of each mass variable. And...
  2. J

    Application.Transpose Appears to be Adding Row to Vector

    I have a 1x3 vector, "Watches" type is Variant/Variant(1 to 3), that I what to transpose with the Application.Transpose command. After the command executes the Vector is not a proper 3x1 but appears to have added another column, "Watches" type is Variant/Variant(1 to 3, 1 to 1). I would have...
  3. S

    Lookup within Vlookup - Search more than one cell and use vectors instead of array

    Hello there! I have the following sample setup: Excel | Flickr - Photo Sharing! (sorry I tried attaching an image several times and it didn't work) I am trying to find words from column E in either cell A2 or cell B2 (preferably it would search A2 and if it didn't find anything would then...
  4. A

    vector multiplication.

    hi, i need help in knowing how to use an array formula for the following (and even help in knowing if i need an array formula!) i have my data in pairs like this: (ax1, by1),(cx2, dy2),... (im using the numbers 1,2,3... only as index to denote the pair, not as powers!) and in excel i have...
  5. E

    Trying to average average from several non-contiguous columns

    What I am trying to accomplish is this: I have construction quantities in every third column (beginning with Col N) that I wish to group in together and average based on 3 size catagroies (Small, Med & Large). Right now I have the upper limit of the Small and the lower limit of the Large...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top