multiple criteria

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

Good morning or afteernooon to everyone: I've this little piece of VBA code that it's not working: Select Case PAc_ALACase Is <> 5, Is <> 10, Is <> 15, Is <> 20, Is <> 25, Is <> 30, Is <> 35, Is <> 40 Do whatever End Select Where PAc_ALA is an integer. Anyway, I tried in a different...

Hi Trying to create formula foe the below table which has multiple criteria x Qty x Duration (with two dates) Attached sample file: Eg for Apple. Same as vlookup to be made for all items like carrot, beans, tv from nested cells. After this, the results will be converted to Pivot table /...

I have a situation where I have 4 contract types and many clients have multiple contract types. I have created a spreadsheet with a "switchboard" so I can select the contract types I want to include in my sales estimates using "TRUE" or "FALSE". I can also set a percentage threshold based on...

Hi all! I have a question regarding on how to get multiple values from different sheets with multiple criteria. What i basically want to do is the following thing: I have multiple weeks (Week 1-52) in all these weeks i fill in the hours that i've been busy on a project with a certain sub-task...