if condition

  1. 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
  2. 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...
  3. 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...
  4. 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 =...
  5. 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...
  6. 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...
  7. N

    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...
  8. 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 -...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. rajkavikumar

    How Hex number works in if statements

    Hello Friends I am trying to understand how I can use Hex in my if statement rather how below mtioned code is working in if condition. Sub test1() Const T = &H1 Const P = &H2 Const D = &H20 R = P + D If R And P Then Debug.Print P End If If R And T Then Debug.Print T End If End Sub...
  19. R

    Need help to get top 10 lowest and highest values with a condition

    Hi, I have a list of names (Column A) and their marks in a adjacent column (Column B). A same name is also listed more than once and hence i am looking for an excel formula that can pull top 10 lowest marks and top 10 highest marks for a same name. I need the output in Column F and Column G...
  20. Z

    How to increment cell value with IF condtion?

    Hi everyone! I'd be greateful if anyone can help me on this complicated query. Maybe easy peasy for you :confused: I'm a structural design engineer and I want to develop my own spreadsheet to calculate required area (mm^2) of reinforcement bars in concrete to avoid concrete cracking due to...

Some videos you may like

This Week's Hot Topics