multiple criteria

Hi, I am looking for an Excel non-VBA function formula based on two parameters. If a cell holds the value 10, then a date starting from 24 December is added, but only if this date is a workday. If this date is not a workday, then it takes the first day before this date that is a workday. If...

IM LOOKING TO FILTER A COLUMN THAT HAS A LIMITLESS LIST OF POSSIBILITIES. THAT COLUMN HOWEVER ALWAYS HAS 5 ITEMS THAT I NEED FILTERED. I NEED TO KEEP "HEADER", "BLOCKING", "SILL", "CRIPPLE", "STUD" AND DELETE THE REST. THIS IS WHAT I HAVE SO FAR. BUT IT DOESNT WORK WHEN I ADD ADDITIONAL...

Hello, I have looked all over but I don't seem to find an answer to my particular question. I am trying to count unique client id values by month and by another criteria, in this case gender. Client ID Date Gender 1121 7/1/21 Male 1147 7/5/121 Female 1121 7/16/21 Male 7865 8/2/21...

Hi there, I'm new to the forum. So please be gentle :) I'm trying to come up with a solution to have a column of numbers appear in a graded color sequence (similar to what the color scales in conditional formatting do), but have the high and low numbers used for the grading changed based on...

Hi there! I have found similar threads on these forums but none that do exactly what I am trying to do. I have a main sheet "Operators" that has multiple columns that I am try to pull data from into different sheets. If column I="Recertify", then move entire row to "Recertify" sheet, pasting...

Hello!!! I have a problem with excel and I will explain you with 2 pictures. As you can see there is 2 slides "Inventaire" and "data" and i want to take the value from the sheet "data" and put it in the table in the sheet "inventaire" So in the sheet "Inventaire" colum "L" (D) and "M" (E) i...

I have been trying to solve this for about a week and cannot seem to figured this out. I have several sections of a worksheet that is for 10 types of work being performed, the status of the work, and an estimate of the cost of that work. It looks like this, but has a lot of other items in...

My title might be confusing. So, here goes. I'm attempting to create a summary sheet of sorts for a weekly schedule. There are multiple tables throughout the workbook that represent days of the week and tasks for each day. View a portion of one of those tables in my "Thursday" tab below: I...

Hi, The program reads each row of Sheet 1, scans the three criteria we are looking for and it should find the entry in Sheet 2 that matches the criteria. Criteria: 1) invoice number (location in Sheet 2: column D) 2) date of payment (location in Sheet 2: column B) 3) amount paid (location in...

Hello. The attached photo is just an example. So I have this workbook that has multiple sheets like this where I would have to run the same type of code. In one sheet I have at least two lookup values. Another sheet I have a file like the one attached. Referenced as Raw data. One lookup value...

I can't download your add-in due to work IT restrictions, sorry. I'm trying to hide rows too and I know I'm doing something wrong. If the values in $i3, $J3, $O3, or $Q3 =0 then hide row, if not then don't hide row. then go to the next row in file. I have this: Sub HideRows() StartRow = 15...

Hi there, I'm very green to VBA and am trying to write a code to run multiple data validations in tables, each with their own hard stop error message. The spreadsheet is a data entry spreadsheet and here are the rules: 1) data entered in cell must be numeric - Shading cell with light red color...

Hello, I have a few question about sumproduct formula here: On the Data! sheet I use [=IF(COUNTIF(C9,"*+*"),RIGHT(C9,LEN(C9)-FIND("+",SUBSTITUTE(C9,"+","",2))),"")] in D9 to extract overtime period from adjacent cell (C9) and from this point I've use...

Hey, I have read some similar threads here and tried some of them but still no solution for me. I have a large database where I would like to list all destinations of each driver for certain days. The main challenges are 1. any driver can appear in any of 3 columns, 2. there can be more than...

Hi there, I'm working with a data sheet and am trying to get the Nth largest value in a specific column based on multiple criteria. My single criteria formula works fine, this is it: ={LARGE(IF('Sheet1'!C:C=3,ABS('Sheet1'!W:W),""),1)} However, I run into the #VALUE! error once I add another...

Hello All! I'm trying to create a formula that counts the number of unique dates with two criteria. I've actually searched within this forum and found a similar question, however because it was case-specific and the conditions differ to mine, the same cannot be applied to mine. The one with 2...

I tried to return a value in sheet1, column A (vertical), to sheet 2 (Horizontal format), if the "Process_Step" and "WO" is matched. As the data is huge and there're many columns, I do not know how to specifically to use the index and match or vlookup, to return the column A value (Date) if the...

Hello, I'm wanting to sum a specific column if it's within a specific year and meet's a specific criteria. For example (please refer to attached pic). I'd like the sum of all Dues & Subscriptions in 2017. So far I've been able to use the text to come up with an amount using the following...

Hi, I need to convert several currencies across multiple rows into GBP by looking up a conversion table and then provide the sum in GBP. I haven't been able to come up with an elegant formula (an array type formula maybe) to keep it short and simple. for the SUM in GBP, I've got the...

Hi everyone, I need to create a lookup which returns a value based on 1.) an employee ID 2.) a date range. I have included an example image. Basically, I need a formula for column H which returns the correct Union of an employee, based on their ID and the award date (column G). The dataset...