cse array

Hi! I have been working on implementing MRP Excel solution in a company I work for. I have already done one, and now I was working on a new more detailed system. My company prohibits me to install XLB2BB add-in so I will do my best to explain everything. First sheet 'ProdBOMs' contains Bill of...

I'm sure there is a pretty simple answer to my question but I cant seem to figure it out. I have a list of products by store and their sales. I want to transfer the product from some stores into other stores that are actually selling it well. Here is the array formula that I have which is...

Hi there all. I know how to do a sheet1.cells(x,y).formularray = "=formula" but I'm trying to accomplish something a bit different. Using INDEX MATCH within VBA I can return a simple single column match, such as: sheet1.cells(x,y) =...

Lets say I have months of the year from Jan to Dec and for each a formula that requires an array formula. The formula takes a long time to run ~ 45 mins but I can live with that. When I type the formula under Jan I must CSE then wait 45 mins for it to run. As of typing this message I have...

Here is my excel example data: Cell A1 = 26,4,12 Cell A2 = 4,4,5 Cell A3 = 0,3,3,3,6,5 I'm trying to get the following results... for MAX: B1 = 26 B2 = 5 B3 = 6 for MIN: C1 = 4 C2 = 4 C3 = 0 for AVERAGE: D1 = 14 D2 = 4.3333 D3 = 3.3333 the number of integers in each cell is variable I've...

Hi, Need some help fixing a CSE formula with multiple nested conditions. Formula is: {=COUNT(IF(AND($Y$2:$Y$37263<1,$D$2:$D$37263=AC18),$V$2:$V$37263))} Just returns a value of 1 when it should return something in the order of 3000. What I want it to do is count the number of rows in the...

Hi, I have been posting frequently recently about a CSE formula I am using to count unique records. I now use this formula instead of sumproduct whenever I wish to count unique records. Apologies for the frequent posts. I'm hoping that the following question should keep me good for a while...

I've been editing/hacking formula given to me by the kind people on this forum. My latest edit seems to be failing - I was hoping someone could spot the problem...

Hello, I'm using a formula that I was kindly given once on this forum. It has served me well - I have cut n paste it many times and it has always worked till now. It's an array formula (CSE). SUM(IF(FREQUENCY(IF('all regs'!$C$10:$C$74865>=summary!$C$7,IF('all...

Hi i need some help with my CSE array attempt. I need to explain my problem i have two columns in my spreadsheet (there are others) one column is colours and another is numbers. I'm wanting to work out the median for a list of numbers that correlate with the colour brown - done this and it...