met

Hi guys this one is tricky, well for me at least! I have the following SUMIFS statement that adds column AL when a bunch of conditions are met with my other columns. What I want to do is have an OR statement somehow nested so only one of the 2 highlighted red conditions need to be met. So all...

Hi. I have a macro that put values (from 10 to 15) into 4 independent cells. I would like to have 4 conditions so that only if all conditions are met can the macro run. Let's say my cells are B2,B3,C2,C3. The conditions are C2>B2, B2>B3, C2>C3 and C3>B3. C2,B2,B3,C3 will take integer values...

Hi I have a formula which currently checks a list of dates and returns a figure provided certain conditions are met. The formula I am using is the following one...

Hi all, I am currently making a spreadsheet that needs to hide 30 rows when a certain condition has been met. Does anyone know how to design a macro that can automatically hide/unhide 30 rows (rows 45 to 75) in the first specific worksheet "Sheet 1". The condition that will be met is when...

Hello, I have done a normal IF statement to match a condition to copy over data. As expected, when the condition is not met a blank row appears. I was wondering if anyone can help how so that it just skip to the next line that meets the condition and have a list of data with no blanks. Thanks

Is there any way to prevent saving a file when a certain condition in the sheet has not been met? So, let's say A1 should have the word "red" before anyone can save the file.

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I bought a new Microsoft Surface Pro 4 (Win 10 / i7 / 16 GB RAM using Excel 2016 64 bit) about 6 weeks ago and had numerous issues with it right out of the box. The OS alone has...

I have below data <tbody> A B C D Status Assigned Group Response Resolve Closed Java Met Missed Cancelled C++ Met Missed Closed C++ Missed Met Closed SAP Missed Met Closed SAP Met Met Cancelled Java Missed Met Cancelled SAP Met Met </tbody>...

Hi, I have raw data and need a formula to determine if SLA was met. I need it separated by same day, 1 day, 2 days , 3 days, 3+days from month to month. I need it to then give me the percentage (out of %100) per category to see where SLA was met or not met. I then need to show this in a stacked...

Hi, I have a worksheet full of data for which I would like to create serial numbers, given certain critria are met. I'm using the "While" function to loop through rows, for as long as they have some text. Then I'm utilizing an "If Statement" to see if 3 criteria are met. if so, I would like...

<o12,if(s17><o$12,if(s17><o<o<o$12,if(s17> I am attempting to enter a "Yes" if the cell matches all three criteria and a "-" if it fails. <o$12,if(s17>=IF(O17<O$12, IF(S17>S$12, IF(W17>W$12," Yes ","-"))) - I get a "Yes" if all three criteria are met, but - I'm getting a "FALSE" if two of...

So I am trying to achieve a for loop macro that stops when certain conditions are met. Say A1 is the counter that starts at 0. for every tick you get 20% of A1 +1 and 80% of A1 -1, and A1 is always >=0. The macro stops when A1 reaches say 5. How do I achieve this? Thanks in advance.

A B 1 Laundry $11.48 2 Laundry $9.98 3 Car $2.98 4 Laundry $14.99 5 Garage $19.98 6 Car $8.52 7 Laundry $16.99 8 Stairs $24.97 I would like to count from Column B if Condition in column A is met (Column A is the name and Column B...

Hello, I have the code below running perfectly until the situation reaches one of the condition second to last which is the "8CNT" if it is met then for some reason if the "9END." is met also, it is not run but if the "8CNT" is not met then the "9END." does run Set headers =...

I have a previously asked a similar question to this here: https://www.mrexcel.com/forum/excel-questions/1016146-vba-delete-entire-row-if-column-contains-certain-text-specific-range-data.html But never really got a resolution and it has expanded a bit. I have a sheet with about 12000 rows of...

Hi All,I have the below 3 columns and column B and C are the target value.If YTC is >=65 and STC>= 70, Need to have the value as 10 in column DAny one of the above condition met, then the result must be 5 else 0If YTC is >=55 and STC>= 55, Need to have the value as 10 in column DAny one of the...

Hi! I am having a sheet with 200 rows containing a date in column C. I am trying to count how many rows there is in each quarter of the year containing a "x" in column E. So I have been experimenting with "countif" and "sum" with trying some two conditions formula. But there is always...