multiple criteria

Hi, I have a table that looks like this: <tbody> Item Class Start End Item1 A 50 80 Item2 A 60 150 Item3 A 120 160 Item4 A 150 250 Item5 B 300 400 Item6 B 400 500 Item7 C 50 300 Item8 C 70 150 Item9 C 150 300 </tbody> If my lookup looks like this: <tbody> Class...

Hi, Please can someone assist, I am trying to create a ranking based on multiple criteria. Each section has been ranked now I would like to see who is leading in terms of a "FINAL RANK" based on all the ranks. please can someone assist me? Please can someone assist with a formula <tbody> MBR...

I'm trying to calculate standard deviation based on multiple criteria. I've used suggestions show on this site and on Google, but it keeps returning the SD of the entire list, not just those that match. Here's the formula I'm using: =STDEV.S(IF($C$2:$C$10=$L2,IF($E$2:$E$10=$M2,$H$2:$H$10)))...

I would like to use a formula to return a value based on multiple criteria from multiple tabs. I would also like the formula to be built in a way that it automatically updates if there are any changes to the criteria. Example: Three tabs in excel: Tab # 1 - Complete Data Set Column A has...

Hi all, My first time ever posting a question on a forum, but after using google for 2 days to find an answer I have given up on google. And after searching for best excel forum, MrExcel.com came out on top. I hope you can help me with your knowledge. I am trying to use countifs to sort data...

I need help with a formula to look in a chart & (1) identify brand, (2) determine if a date is between to dates, and (3) return a value of a corresponding event. Here is a snapshot of the data: <tbody> Brand (Col. A) Event (Col. B) start (Col. C) end (Col. D) Brand A Winter Clearance...

Hi, Hopefully someone can help me. I have a chart that lists dates of two brands and some events that run each year for past 2 years. In another tab I have a list of dates between the two brands. I want to first, identify the brand, then if the date falls between the date ranges of a certain...

I am looking to create a SUMIFS using multiple criteria; not sure if what I am attempting is possible, any and all help is appreciated. Below is (to me) what would seem the logical formula, however, it is returning a incorrect sum. Thank you in advance...

Here is an example of what my dataset looks like in excel: Column A Column B Column C Column D Row 2 A B C Row 3 1-1400 .25 .75 .50 Row 4 1400-1500 .50 .25 .30 Row 5 1501...

I am looking for a possible solution to this madness. <tbody> Column A Column B Column C Column D Name Store Visit Store # Date Bob 126 7/12/2018 Jennifer 126 7/12/2018 Chris 126 7/12/2018 Bob 126 7/12/2018 Bob 113 7/12/2018 Susan 156 7/13/2018 Gregory 156 7/13/2018...

the table below is just a small segment of a much larger table. the first instance per person each week is normal time, any other instances that week are overtime. so what im looking to do is sum the total number of hours in normal time, and sum the total overtime per person (ill just take the...

Hey guys! I'm working on a project that requires merging data from multiple workbooks into a single "master" workbook. All files have the same number of columns and have been merged properly. That means all data is in the "master" workbook. I couldn't manage to remove the duplicates though...

Hi guys, very long time lurker but first-time poster. I am wondering if anyone could help me clean up this array formula. I need to be able to count all instances of 0,1,2 except for [0,0],[0,1],[1,0],[1,1]. Please forgive my quick and dirty formula (not safe for looking). It is working as...

Hi Everyone - I have three sets of data. One is organized like this: Table1 <tbody> Product ID Start Date Code 121 4/05/2018 X 131 4/05/2018 V 121 4/20/2018 </tbody> Another like this: Table2 <tbody> Product ID Buy Date 121 4/06/2018 131 4/06/2018 121 4/07/2018 121...

Hi folks I am not very advance user and can write basic codes but I have spent quite a while on this and could not make it work so asking for your help. I have one workbook with multiple sheets as below Sheet1 (Actual Input data for over 400,000 lines) Region Location Accounts...

I used to work a ton with these types of unique extraction array formulas, but am having some trouble remembering if I am even going about this the right way. The formula below is attempting to extract/index a unique value if its length is equal to 18 or 26 or 28. This workbook is large, it has...

Good day. What solution can you suggest to have “match” return value at column D if the code in column C matches with one of the codes in column G. The current job title code is referenced with the table of possible jobs for completers of certain skills training. In short, this is a problem...

I have some times that I am trying to analyze through the use of a helper column. In Column B I have a list of operation numbers, in Column G I have a list of time differences. In the helper column I want to check if the next 5 time differences for the same operation are under 7 minutes. In the...

I'm using the following formula: =IFERROR(IF(SUM(COUNTIFS(INDIRECT(CELL("address",INDEX(MuchAdoSceneAndCast,MATCH('Much Ado Schedule'!C5,MuchAdoSceneList,0),2))):INDIRECT(CELL("address",INDEX(MuchAdoSceneAndCast,MATCH('Much Ado Schedule'!C5,MuchAdoSceneList,0),17))),{"Full...

Hello. Within an Excel workbook I have a worksheet that has 30 columns and more than 50,000 rows. Below, I’ve have copied 7 of the columns and 29 of the rows (not including the two column heading rows). Let’s call this worksheet 201617. On another worksheet (also below), which I will call...