return array

Hi, I am trying to return a contract number from a table of data by looking at the Week number. I am only looking to retrieve contracts with a quantity in the desired Week. I.e. by look at week 11 I would like to receive Orange and Pear. The table looks like: <tbody> Q1 2017 Q2 2017 Q3 2017...

Hello Everyone, I am asking on some topic which is probably not new, so I did some research, yet my problem didnt solve. Another topic which comes close is this one: http://www.mrexcel.com/forum/excel-questions/496921-return-array-index-match.html Not sure if this would have to be placed in the...

Hi All, I have an ODE solver, and I'd like to be able to have the user enter the name of the function to use by name when calling the macro, so I want to use the Run(function_name,arg1,arg2,...,arg_n) function to call the function and pass arguments to it in a more flexible way. This works...

Hello everybody, I´m trying to work out the following problem. I have a range of cells each containing a name. Based on a number that has to be entered manually I want excel to return the names concatenated in one cell. So for example: Number of variable entered: 5 <tbody> q9001 q9002...

Hey, I need a function that can do the following: I have two culoms of numbers temp and pressure. I want to find the max pressure for each temp. I want to do some thing like this: A B 1 200 3 2 200 4 3 300 1 4 300 5 =Max(?????(a1:a4=200,b1:b4)) So ????? returns the...

Hello, I am new to this forum and I am new to Excel VBA. I apologize if this is redundant with another thread or post, but I have looked high and low via google and on this forum and have yet to found what I am looking for. I started with a simple if, then, else function as follows...