multiple array

  1. K

    Sumifs - does not equal to an array

    Hi, I hope an you experts can help. If I have phrased the question poorly, please ask for more information. This is my first post and I'm a newb at excel. I need to create a sumifs formula (unless you can advise an alternative) which will allow me to sum a column which does not have the same...
  2. K

    Creating multiple columns from multiple columns and passing the arrays to other subroutines!

    I'm pretty new to excel vba macro coding! So, not sure, if I'm putting my problem clearly enough! I'm working on a data of thousands of rows and around a dozen columns. Please note there's no unique value column, i.e. even though each column contains a unique set of values, irrespective of the...
  3. O

    Lookup multiple values with multiple criteria, fill horizontally by header category

    Hello friends, a long time lurker-first time poster. This place has saved my *** on multiple occasions. Unfortunately, I have now spent days looking for a solution without much luck and felt compelled to ask my first question. The problem at hand is this. I have a list of employees (by ID) and...
  4. S

    Multiple Text Search

    I have a workbook that I use as a template to import into a billing program. The only issue with is that the software we use, has its an odd naming protocol for the tax areas. I was able to export all the data into a workbook. I need a formula that is able to search for the State, then the...
  5. R

    Formula - MIN & MAX With Reactions To Specified Terms In Seperate Column?

    Hello all, I'm looking to create a formula which looks up the minimum and maximum supplier credit terms, which also takes into account whether the terms are net (just the days listed) or end of month (plus 30 days)? See below for required detail: Layout of relevant column headers: G2: Payment...
  6. T

    Look up with multiple returns

    Hi, I have a massive dataset (big for me) of just under 10000 lines. I want tbe data to two thing. The first I have achieved, being if a vlookup of airport codes, so put in the 3 digit code eg A1= LHR, and it returns B1= Heathrow C1=London and D1= UK. What I want it to also do is if we have...
  7. B

    Multiple array

    I have lots of cells that contain formulas with arrays. How can I update these without: clicking the cell clicking the formula bar then hitting CTRL+SHIFT+ENTER I know you have to use CTRL+SHIFT+ENTER to "activate" the array. For instance, my formula is...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top