met

I have created an array formula that checks specific conditions in a row, and returns results based on those criteria. The conditions are as follows: 1. Condition A not met - number stays the same 2. Condition A met (but not all three conditions) - increment number 3. All three conditions met...

I am certain this should be an easy fix however I am having a terrible time trying to figure out why my formula is not working as it should. The below formula worksif conditions are met, but not if they have not been met. For example each cellreferenced has a date for its value. I want my...

I am trying to use an auto filter on my information but the criteria is 12"MET and i don't know how to allow for this in my code because of the quote marks. Is there anyway i can do this or is there a way my filter can search for the 12 and then the MET and return all the results that contain...

Hi All, I have setup the below formula to return the count of people for each category. =SUMIFS('MASTER TAB'!IY:IY,'MASTER TAB'!IW:IW,"Employee",'MASTER TAB'!IX:IX,"£0 to £10k") IY is a column within the master tab which has a default value of "1" for each employee. IW is a field within the...

How do I make it so I can see which activities should have been completed in a certain time frame (e.g 1 month). Which ones have been completed, and then which ones have over ran, so have not met their deadline. And can these also be counted up at the end? So a total of completed and not...

Hi I currently use =IF(A2>0,NOW()), which is great when A2 meets the criteria, however when A2 does not meet the criteria, A2 displays False. I would prefer that A2 was just blank if the criteria is not met rather than display False. Does any know/have the solution ? MTIA & KR Trevor3007

Hi, I'm hoping someone can help me with a macro which will highlight a value in column C based on certain criteria So all the criteria must be met on each row, so if L2=True and M2=False and C2>=1 and if D2>=1 then highlight cell C2 yellow but if D2=0 then highlight C2 Green. I want it to do...

Hello, Can I make a formula that will sum cells from a specific point to the right, and stop until a condition is met? Thanks!

<tbody> Score Rating 80 45 </tbody> What formula do I use to get the rating to show up as Below, Approaches, Met, Masters based on the following: If score is 40 or less equals below If score is between 41 & 62 equals Approaches If score is between 63 & 78 equals Met If score is 79 or...

Hello, I am trying to insert a macro that will pop up a message when a condition is met. I use the following code: Sub Worksheet_Change(ByVal Target As Range) If Range("B4").Value < Range("C4").Value Then MsgBox ''Limit has been reached'' End If End Sub However, it doesn't...

Hello, On paper, I think this should work. I want to make a formula that if special criteria are met, then a separate formula is calculated based on its own special criteria. If the first criteria is not met then nothing happens. This is what I started with...

I am trying to get a formula to count the values in column I but only if the value in column D is equal to B2. I need the result to be the largest amount of instances of the value found. In simple terms, and assuming the criteria is met, I need to identify the value that occurs most frequently...

Here's the current code: 'SH DATA COL P = DUE DATE Worksheets("SH Data").Range("P2").Formula = "=IF(AND(OR(J2=""NEWCLAIM2"",J2=""WEBRECVD"",J2=""KECREATED""),ISBLANK(M2)=TRUE)=TRUE,WORKDAY(D2,O2),IF(Q2=""REWORK"",WORKDAY(D2,O2)," _ & "IF(OR(Q2=""QUESTION"",Q2=""RQMT...

So I need a cell to check multiple cells to see if the criteria is met. If the criteria is met the hidden/transparent cell goes green. Criteria: G6 OR G9 are not blank AND G25 OR G26 are not blank AND G22 AND G28 are not blank AND G29>19 Thanks for the help

I need a formula that will count the number of times the value "N" appears in cell B10 and E10....if "N" does not appear in either cell, the recipient cell (cell G10) is to remain blank <colgroup><col width="6" style="width: 5pt; mso-width-source: userset; mso-width-alt: 219;"> <col...

I'm trying to copy data across to another sheet if a condition is met. The condition is the value 'Unresolved' in column K - this is what I have so far; Nextrow = Sheet14.Range("A65536").End(xlUp).Row + 1 For Each cell In Sheet7.Range("A2:A" & LastRow) If cell.Offset(0, 10).Value =...

Hello, Probably simple question here, but I am struggling with SUMIFS and SUMPRODUCT so I am reaching out for help. I have 3 columns: Two have values that need to be multiplied if a condition in the 3rd column is met. For simplicity, here is an example <tbody> Value 1 Value 2 Criteria 2 10...

I have a spreadsheet that I am trying to come up with a way to look at variations in two different cells ad if they are met to highlight the cell. For example I am currently using =OR(D6>=1000,D6<=-1000) - this is to find any vales greater than or equal to 5,000 or a negative 5,000...

Hello, I'm trying to have a function reference one cell, in this case F762, to see if it says yes. If it does, it will print a value based off the value in G762, using a lookup function I've already proven to work. If the condition is not met, it should use a different lookup function that is...

Morning Everyone I am hoping to get a little help. I'm stuck on my formula. Using standard Net Promoter Score surveys I am looking to calculate how many promoters are needed to attain goal. the formula we use is the following P=Promoter N=Neutral D=Detractor (P-D)/(P+N+D) What I have so far is...