multiple criteria

Hi All, ABCDEFGHIJKLMNOP DateSkuCodeQtyPoOrder#NameShip DateTrackingCourierInv#CostShippingVatTotal Inc. VatStatus =IF(OR($B4="",$D4=""),"",IF(B4="","",(VLOOKUP(@$B$4:$B$500,Formulas!$A$1:$F$26,4,FALSE)))*D4) I am using the above formula in column L and M to pull in a cost price for an...

Hi everyone, Could I get some help with my formulae. Below is my pivot table I created from a data source. I defined this as PivotTableRange under sheet called Data - Pivot using =OFFSET('Data - Pivot'!$A$1, 0, 0, COUNTA('Data - Pivot'!$A:$A), COUNTA('Data - Pivot'!$1:$1))...

Hello - In my example below, I'm trying to use an array formula to filter the Top 5 "Accounts" in column AA based on the "Sumif Labor Cost" in column AB. I want to ultimately do this with a single array formula in cell AA13. I've provided the rank in column AC to show the top 5 items that I want...

Ok board!! I ve searched under all available rocks & stones and has not yet figured this out. Please note that my Duplicate Values ARE not the normal ones, i came across all the solutions available out there. I paste the below table, with the wanted ranks: CY T.O Pax Rank CY T.O Pax Max Rank...

Hi all, I am trying to calculate the percentiles in a frequency table, but I'm having trouble creating the cum sum with multiple criteria - the idea is to replicate the values in column D State Color Count Cum. sum for "blue" per state Alabama Blue 2 2 Alabama Yellow 4 Alabama Blue...

Hi All, I am running a basketball league and need to make the results and standings easier to see with minimal input. I have all the results as they should be using the NBA format. However, I want the spreadsheet to tell me the position of the team automatically based on win %, conference...

I have been working on this for a couple days and it is frustrating. I have found many Posts about simple matching of criteria, but I cant figure how to make any of those methods work for my situation. I have 2 worksheets in my book. The first worksheet is a master list of addresses. The...

Hello, I'm currently using the following CF Rule to highlight cells in two columns that meet a single criteria from a list on another sheet. =SUM(COUNTIF(C2,"*"&INDIRECT("t_Whitelist[Author-Series]")&"*")) However, I would like to expand my criteria to only highlight the cells that meet the...

Hello! I have two sheets within a spreadsheet: Report and Rates. Report contains an account listing with a concatenated name in column S and a start date in column H. Within Rates I have triplicate rows containing the same concatenated name for each time frame in column F. Column G of the sheet...

Bit of a complex question this time. I want a formula in column E that will return a value from column K, based on whether Column B corresponds with Column J - using cell K2 as a guide. I've been trying to play around with the VLOOKUP formula, but it's clearly not working. Help...

Is there a way I can shorten this formula. Works - This adds "US", "VI", "PR", and excludes "CA"...

Hello all, I thought this would be straightforward but, no I keep getting "Not Found" when I can see a value? Note the two columns of the GPR_Data worksheet B:B and F:F contain multiple instances of what I am looking for but if used together they will provide a unique reference. I've tried...

Hi All, I have this simple assets tracker attached below. What I'm hoping to do here is to auto-populate the name from Column C (Assigned To), into Column I (Reassigned To) when the same device (by serial # in Column B) has been reassigned to a new user. I've tried using the INDEX w/MATCH...

Hi All, I need my formula to look across multiple sheets if it does not find value in the current sheet. So my current formula is =IFNA(VLOOKUP(I4,Sheet1!$A$2:$D$10,2,0),VLOOKUP(I4,Sheet3!$A$2:$D$10,2,0)) I want this to search across 3 or more data sheets, but i get an error...

Hi and good afternoon, I am struggling to get a formula for countifs to work and i beleive this is due to my criteria ranges not being of the same size. Is there any work around to this? i have put my example below but the actual data set is much larger but i have the same problem. the data set...

Hello and thanks for reading this! (I apologize for length, but want to be thorough so you don't have to try and read my mind. Good question = good answer right?) The code below works the first time through, but the code will be ran multiple times. It's a two step copy and paste based on...

I have a table with three criteria. Two criteria are stated in columns, and one in a row. The table looks like this: I want to find a value which matches the three criteria. For example: I want the value for 'Cembrit Cetris Basic' , SC1 and Permanent. Then a value of 0.3 (cell C3) should be...

Hi, I have 2 Sheets(workbooks in reality but I made the test sample in 2 sheets). DATA sheet: All text/numbers. No formulas in this sheet. RESULT sheet: CFGMNOP1IDItemBalanceMatch Failed (Accessorials)Invoice Rejected (Accessorials)Approval Failed (Accessorials)Amount Due233283896Stop-off...

Hi I have written the following formula as a conditional formula =AND(C$20=Sheet1!$D$46,C21>=Sheet1!$D$47) which highlights values based on 2 criteria. This can give me up to 3 results and i only want the closest one to one of the specific criteria values not all possible answers. How do i...

Hello there - I keep forgetting how to think about the logic of these functions. I tried to look across my other workbooks for formulas. I feel like I've done this before so I apologize but I couldn't find the formula hence why I"m posting. I've searched and using these links and posts as...