multiple conditions

I am trying to find a method in which to detect 2 separate Text Strings within a given cell. In a nutshell - user input on a form I have is not always what it could be. So, if the expected answer would be "No Luck," some users will invariably enter "No Luck." Unfortunately, according to...

I have a dataset with numerous combinations of alpha and numeric values in a given column. I need to do TWO things. 1) Determine if the 1st character is numeric - if so, the initial condition is met. 2) If numeric, is the character between 1 and 9 (greater than 0) - if so, the final condition...

I have a massive workbook covering +/-50,000 rows and 30 columns. I’m looking for guidance for four scenarios, which are listed below. Thank you in advance! For a given column, T, U, or V, I need to count cells that contain AR3, BA1, BA3, BA5, HO* (HO* represents HO1, HO2, and HO3), WC1, WP0...

Hello Excel Gurus, I have been redoing my companies time sheet to make it easier to fill in but I got stuck at this. The left and right sections represent two different sheets. What I'm trying to do is: If Tuesday's job number is the same as Monday's put the hours in the same row. If not put it...

Hi, I want to calculate the winner by fulfilling these following conditions. For example I gave a Winner list at the bottom of this page. Conditions: 1. The Winner will be he, who achieved maximum Sales 2. Department "A" winners cannot exit 6 <tbody> <tbody> 3. Department "B" winners cannot...

I am trying to find a formula that will return the data for corrective actions that are repeat issues that are within a date range. I have a summarty table that will contain the repeat issue data once it is pulled from my main table. So I need the formula to look at my main table (contains...

Hello, I am trying to write an IF function with two conditions, SUM(C2+D2+E2+G2)>0 and SUM(B2+F2+H2+I2+J2+K2+L2)=0. So only if certain fields are filled in and others are 0 I want it to return a value. I have this so far but it does not seem to work properly =IF(AND(SUM(C2+D2+E2+G2)>0)...

Hi, Everyone I am having trouble finding the best formula to calculate how much i spent on a particular item per year. The issue that I am having is when my monthly payment spreads across multiple years, I can't seem to create a working formula that can account for the cost that spreads into...

Hey, I am trying to figure out a way to automatically create all possible conditions of the following set automatically in excel: <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Christian Man Straight Black Able Muslim Woman Gay White Mental...

Hello Need some help on a formula I'm trying to create. I have a massive expanse of data, 50000 lines of data. One column is PO number, one is week number and one is a delivery booked column. I need a formula where by I can type in the week number and then the formula will find the cells for...

I've been asked to add a separate column to a spreadsheet specifically to indicate RAG status. There are multiple options within the RAG alert system, though. I need column F to show Top, Strong, Good, Developing or Under, based on the values in column E, as follows: 5% or less = Top 6% -...

Hello everyone. I have written the formula as seen below and works like that: In the A6:A35 is looking for the codes that have as a 7th and 8th letters "CN" and then in the B6:B35 is looking for "Reliable". Then for the month August (j6:j35) it sums the amounts for the above criteria. What I...

Hi all, This one has me puzzled like crazy I just don't seem to get it right without writing a large book of code for all exceptions. So here's the case: I have a workbook with two sheets. Sheet1 contains a large table (20.000 rows, 100 columns), but looks simplified like this: The...

I am using a nested IF formula with multiple conditions that looks at two cells (D7 and C7). See below: =IF(AND(D7=100%,C7=100%),5,IF(AND((D7=100%),AND(100%>C7,C7>94%)),4,IF(AND(D7=100%,C7<95%),3,IF(AND(D7>89%,D7<100%),2,IF(D7<90%,1,0))))) The table that is used to qualify the resulting...

Hello, I need help with a formula please! :) I'm creating a summary page that shows amounts per month. I am trying to create a formula that will go out to the correct tab, and return a net amount when two conditions are met. Below is an example table. I want the formula to return the sum of...

Hi I have a table with multiple columns and I want to calculate the number of SKUs using their codes without counting the duplicates with the condition of this sku being small griller, regular sku and in june my table looks like this month sku code sku type family 2 jan 1234...

Hi, I have received help from all of you before and I hope you can still help this time. Thank you in advance. I am trying to create an attendance tracker system for a small start-up account until our web team is able to develop a program for us. We have two shifts, 700-1600 and 1100-2000. I...

Hello, Trying to build a ranking formula that takes into account total score for duplicate identifiers, as well as a tie-break for the duplicate total scores. The goal is to return a rank for each, without skipping any ranks, with duplicates scores rankings based on the Tie-break. However, the...

Hi All - I have a nested IF statement that only partially works. <colgroup><col width="114"></colgroup><tbody> IF('20160229 ESD POS Import'!L3="B&H Foto and Electronics","005D0000003916X", IF('20160229 ESD POS Import'!L3='Special Accounts'!A:A,AY3,IF(L3<>'Special Accounts'!A:A,AV3)))...

I want cells data in column B to color green if colum A fulfills some of these conditions (in table below). For example if SIZE is greater than 4B in cell A1 and GROWTH is greater than 5% in cell B1 then cell B1 to be in green or if A1 is between 0.4B and 4B and cell B1 is 7% or more then cell...