array formula

I have inherited a spreadsheet with a calendar and task function still used by many people in the organization. I'm told that the original owner back in 2009 got the idea from a Chandoo post. Certainly the appearance is elegant (xl2bb doesn't give all the elegant formatting) and it's rather...

Hi there, I have two tables for labor rates by function and by year. One table for GBP currency, and one for USD currency. I then have a table that contains labor hour requirement by contract (many rows). Each contract is either native to GBP or USD. I'm trying to use the following formula to...

I am looking to do an array formula with a partial string match. Does not seem to be working. Are array formulas different than regular index-match formulas with partial string matches? This works great...

Hi I created an ErlangC formula for my excel: at the end, I want to use Array formula to sum it up, but it won't work. can you teach me why it won't do it? Thanks, Day Date Interval Forecast Schedule Calls Per Hr AHT Fcst Vol Target Ans (sec) ErlangC Sun 4/2/2023 8:00:00 AM 9 15 20 329 10...

Hi to all, I'm trying to understand better how it works certain Array Formula and I see that "Evaluate Formula" is a great way to see step by step how it works the formula. The issue I see is that the window of "Evaluate Formula" is very small and is needed to scroll down/up for each step, and...

Having a table like below with 3 columns, is possible with an array formula to show dynamically which countries (Country Abbreviation) are related for each medal type (gold, silver, bronze) and season? below is shown countries for each season, when in cell is entered "Gold". In this example, the...

Please check out my Excel Range. The Array Formula should copy all ItemCodes from Sheet 1 to Sheet 2, where "Below Stocklevel" value = 1. But somehow it's doesn't do anything. What am I missing? This is the source table: (Sheet1) ItemCode Below StockLevel 1300011 0 130021 0 130022 0...

Hello! I've got a question about an array index match formula that's partially working. So the set up of the data is on sheet2 I have the raw data being downloaded. On sheet1 I have a table with the formulas pulling back only the relevant information from the data dump. The table set up is...

Hi Everyone, I have been working on a table for several days. I need 3 formulas. There are a several different functions and several different alternatives. I hope someone can help me!! In the table here, I need to find the conflicts and offer alternatives. In Conflict Formula for column G =...

Hi all, I'm new to using array formulas so I am struggling to work out how to speed up an array formula. My array formula returns the latest referral date against each customer (column A stores the unique customer ID and column U stores referral dates): {=MAX(IF('ACP Data'!A:A=$A2,'ACP...

I'm looking for a formula that can do one of two things. Ultimately I don't care which one it does because I can make either of them work but if I had my preference I would prefer something like Solution 1. I have two worksheets (let's call them SheetA and SheetB) each with the same headers...

Hello everyone, Hopefully you can help me with this. So i have a list of values (not in any cell) that I need to check against a single value. I want to check if 2 exist in {3,4,6,12,2} and the result would be TRUE or FALSE My intial statement was =2={3,4,6,12,2} but the results comes in...

I am getting nth smallest value with multiple criteria but couldnt get the position of it. I need postition to lookup other values in the same row of the nth smallest I used the following formulas =IF(AK$2=0,"",IFERROR(SMALL(IF($K$4:$K$20=AK$2,$I$4:$I$20),$U$4:$U$20),"")) No issue with this...

Looking for advice on array formulas. I'm a school teacher making a spreadsheet for my school that plots children's progress in different subjects across the year. Someone helped me write this formula which I have been able to apply to different terms in the same subject (columns A:N in one...

I am trying to build a formula where the below values are pulled from a table where......SUPPORT = A1 WINTEL = A2 CITRIX = A3. The only way I can get the formula to work is to list out the value string as indicated below in purple. If I ever want to change the value string, I would like to...

I’m trying to create a tab in a live google sheet that acts like a bank register with multiple accounts. It would have a sender ID column, a receiver ID column and a transaction amount column. What I’m now trying to build is a column which outputs an account balance for the sender at the point...

Hi, I have the below base data that I want to split in to individual sheets. So that each ID has its own sheet. ID heading is in cell A1 ID Name Detail Date 1A Joe Arm procedure 24-Mar 2A David Leg procedure 12-Feb 3A Sarah Shoulder injection 01-Apr 1B Hannah Knee Pain 03-Feb 2B...

Hi All, The situation that I have is the following: Sheet1: (start and end times of orders) Machine (CELL B1) OrderNumber (CELL E1) StartTime (CELL P1) EndTime (CELL Q1) Machine1 00001 Machine2 00002 Machine3 00003 Machine4 00004 Machine1 00005 Machine2 00006...

I tried to find help with this question on Stack Overflow here but did not get a complete answer. I use this Google sheet to track proofreading jobs. I'm trying to modify the array formula in P1 that calculates the billable total for each job. The formula currently uses the Turnaround and...

Can you please help me find a way around Can't figure out why this one working: {=COUNT(ISNUMBER(SEARCH(List,E522))*(ROW(List)-1))} Which evaluates in something like COUNT({2,4,6,2}). And it results in 4 Now I want to count only 2. So I use...