# vector

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

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back