if condition

  1. Z

    Years into groups

    Hi! I have column which has several termination dates and what I need to do is to group those dates into years as showing below: - Less than 1 year - 1 year - 2-3 year - More than 3 years What is the best formula to use? Thanks!
  2. D

    Copy cells from files in the loop and paste them transposed to MasterFile.

    Hello everyone, I have a macros which loops through multiple workbooks (csv files) in a folder C:\VBA\, and makes changes to numerical values of each file, as a result of changes the value of the certain cells in the column “M” becomes (while the code is still processing CSV file) equal to BUY...
  3. B

    VBA code to loop throug a column and find/replace

    Hello People, Can someone help me with below requirement. I have a cell address stored under address1. now I want a code which loops through entire column of "address1" and if a number zero is found then it has to check the value of its immediate left cell and 1. if it is NA then zero should...
  4. K

    If array is empty - condition VBA

    Hello there, I need a contiditon that checks whether an array Ary1 is empty in VBA. Can you help me with that? Thank you and best regrads, Kristina
  5. K

    Comparing two arrays and go to if-condition if match was found

    Hello, I have two arrays Arr1 and Arr2 that both include a list of words. I need a code that compares every element of Arr1 with every element of Arr2. If at least one match was found I wan't to add more code. So it would look like this: If Arr1=Arr2 Then ... The comparing part is not working...
  6. C

    IF Condition help (I believe)

    Good morning Mr. Excel community, I have a questions and wondering if you can help! <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}tr...
  7. R

    VBA HELP Adjusment of data with if-condition

    Hello everyone, First of all I´d like to thank all participants on this website, which help me a lot to improve my VBA skills. I hope to get help with my issue :smile: Don´t get shocked about my long text, the main work is done and works. So, Two workbooks 1 =...
  8. K

    Timeline Conditions

    Dear Experts, I need your help regarding timeline, i have below data from style to last date and i want to calculate day wise quantities according to below criteria. 1.5 Change over days are constant and days required are calculated =4000/800 >> 5 +C/O days >> 6.5 days. 1st Day Plan: 25% of...
  9. B

    If Range.Value = Yes then copy data to LOG RECORD - Records are overwriting

    Hi Community, I have a VBA macro for a log record that copies information from a submission form and pastes it in a Log Record data file based on a IF condition. THe condition is partially working where if the condition is true then the data is copied to the log record, But when i try and...
  10. Navi_G

    If Condition with Conditional Formating

    Dear Experts, I need a if formula that solve my problem with conditional Formatting. Like, School scores grading on below Illustration</SPAN>: i) less then 33% Grade Result F and showing in red ii) 34% to 40% Grade Result E and showing in yellow iii) 40% to 50% Grade Result D and showing in...
  11. S

    IF condition

    I have to change the name as per the group in 'Type' column. it is working fine if it is represented as single name, but not with multiple names. Eg., For Apple, Orange, Watermelon, it should come as Medium, Soft Formula used in 'Type' Column -...
  12. M

    restart numbering based on formula

    I have set up a sheet with automatic numbering based on formula based on “flag” field. Flag “h” is for headings Flag “”m” and “s” are for Sl. No. field If flag is “m”, then the Sl. No corresponding to that item is incremented by 1 If flag is “s”, then the Sl. No is corresponding to that item...
  13. V

    Satisfy if condition on Dynamic columns

    Here is my question. I am looking for a value "Y" in Columns Y: AW and if Y then return " N " else "Y ". I got it to work in cell AX2 using formula IF(COUNTIF($Y2:AW2,"Y"),"N","Y"). Having trouble to dynamically update columns when new columns are added after AW . I need column Y (the...
  14. S

    If Condition & loop Condition

    Hello, My Question is need to display a text value "Started" & "Completed" cell a1 has start date Cell B1 has End Date display c1 "Started" or "Completed" based on the a1 and b1 dates.. a1 = 10th may (10-05-17) b1= 20th may(20-05-17) I have one more cell also , total number of...
  15. K

    Condition Formula

    Hi, I have this table ... this is a part of millions of records. I have functions that show if STAT is 1 or 0, if type is E, if type is CA. This example shows that the same work 24188686 has one E and two CA. If I filter columns I can see either E or CA from the same work. I would like to...
  16. J

    VBA - Search files in a folder, copy IF problem

    Hi everyone! I'm a total VBA newb and I require some professional assistance getting my code to work. I've searched far and wide with no luck and I'm getting quite desperate. All kind of help will be greatly appreciated! In short, I need my code to search through Excel workbooks in a...
  17. S

    How to calculate my MBA results?

    Hi everybody at MrExcel, We are from a university. We have SIX specializations, Specializations------Codes Finance ----- F, Marketing ----M, HR ----H, Finance with Marketing ----FM Finance with HR----FH HR with Marketing------HM We have six subjects in each combination i.e...
  18. A

    Multiple IF conditions to calculate percentage value

    Hi! Here is the values and conditions: <tbody> A B C 1 Customer Target Achieved Commission 2 Bernard 54882 3 Norbert 13420 4 Maggie 91472 5 Smilly 33542 </tbody> Coniditions: Target < 15000 commission is '0' Target > 15000 < 30000 is 2% calculate commission value...
  19. P

    Pivot Table - Calculated Field - Counting Distinct Values For with If Condition Met - Excel 2013

    How can I create a calculated field in a pivot table that will count distinct values of Field1, given that Field2 meets a particular condition? My limitations: Needs to be in a pivot table Needs to be a calculated field The calculated field needs to be a unique count "formula", not simply a...
  20. M

    help if and macros

    I got a list of clients that have food restriction like this: <tbody> Client Restriction1 Restriction2 Restriction3 Restriction4 Restriction5 Zed Rice Pasta Fish Fried Food Apples Charles Rice Fish Fried Food Carl </tbody> And a list of foods that I serve in my company like...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back