cse

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) =...

Good evening everyone, I have a workbook that uses a lot of array formulas (no way around this), and, after adding dynamic array formula worksheet hyperlinks to the mix, the workbook slowed down enough for me to notice the delay in calculation on my Mac Mini (quad-core i7, SSD, and 16Gb RAM)...

Hi, I have used the following formula to look at a data range (in J3:V3) and return the most common string (the data is simple, either "RED", "GREEN" or "AMBER") {=INDEX(J3:V3,MATCH(MAX(COUNTIF(J3:V3:,J3:V3)),COUNTIF(J3:V3,J3:V3),0))} It works fine and returns what I was after, but I can't...

Hi there, I have a quick question regarding the use of arrays with '=SKEW'. According to this guide: SKEW - Excel - Office.com Skew accepts 1-30 arguments. As the dataset I wish to calculate the skew for is 100+, I therefore have 100+ arguments. The guide recommends creating an array to...

How do I get the value that matches for each of these? Desired result in C9 is "Alpha". This is also a CSE formula...

Hi, I'm trying to match multiple cells of data to a table. I figured out (using other threads) how to get one set to match another, but am trying to figure out how to get multiple sets to match in different orders without spelling them each out. In the end I'm looking for the name that will...

Hello - I'm trying to calculate a minimum value from column J when data in column E meet one condition (="1") AND data in column I meet one of two conditions (="E" or ="_"). I can calculate the min using the two conditions in column I, but not when I try to incorporate column E. Formula for...

MrExcel has a great example of CSE formulas posted on http://www.mrexcel.com/articles/CSE-array-formulas-excel.php My question: how can I add a condition to ignore zeros or empty cells? I tried: =AVERAGE(IF($C$2:$C$10<>0,IF($a$2:$a$10=A13,$C$2:$C$10))) But it doesn't work.

Hi - I have two ranges in Excel that contain vectors of numbers. While the two ranges/ vectors are the same length, there are multiple sets of such vectors of varying lengths. I'd like to develop a formula where I can use an identity matrix as part of the computation with dimensions equal...

Hello everyone, this is my first post to the board I've got an excel question that is a real humdinger. One of my spreadsheets has a list of which hotels people have stayed in: <TABLE style="WIDTH: 258pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=344...

Hi everyone, I would like to count the number of occurances of a number in a list. The list is generated by the RANK formula as shown below. Sheet1 <TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial Narrow,Arial; BACKGROUND-COLOR: #ffffff"...

This CSE formula is not giving the expected results and I am tearing my hair out as to why? No matter what values I put in column F to match too Excel is only returning one value not the total e.g. if I have two entries with reference 2010-20 in column F with two values in column AZ (say 13 and...

Hi - I'm trying to use a CSE function to sum a given range based on criteria applied to a separate range of the same dimensions (i.e. the {=SUM(IF(...))} convention). The challenge is that the criteria to apply is a list of user-defined substrings present in the range to which the criteria...

I've been using CSE formulas (primarily countif and sumif style) in a pretty huge budgeting and forecasting file. The file is getting out of control in terms of calc times, etc. I've been doing some reading up on DSUM and it looks like it could save a ton of processing time, but I fear it won't...