• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    Msg - Function in formula causes result to change when excel calculates

    Thanks for reply. I'll look further into. DK.
  2. C

    How can I add more criteria to this code

    Hi Deepak This works. Thank you. DK
  3. C

    How can I add more criteria to this code

    Sorry - How do I edit my post.
  4. C

    How can I add more criteria to this code

    This code works well. I need to get it to work with more criteria. 1. - I would like to be able to have Criteria1: = "I" or "S" As a new piece of code I need to 2. - I would like to be able to have Criteria = "I" or "S" for Range "I" but also Criteria = "U" for Sh.Range "V". Sub APExtract()...
  5. C

    Msg - Function in formula causes result to change when excel calculates

    Hi Luke Sorry for the delay in responding to this. I now understand that by using TODAY this is creating a volatile formula. I also understand what you have done with the formula. I made one error in that the AR34/30 should have been AS34/30. This is picking up a number value of 0 or 30 or...
  6. C

    Msg - Function in formula causes result to change when excel calculates

    I thought this formula was ok but the result keeps changing. When excel calculates its ok and then I go and do something and suddenly its not. When I went to evaluate formula if gives the text above. Any ideas? Thanks DK...
  7. C

    IF AND OR Statement

    Thanks Smallman [SOLVED]
  8. C

    IF AND OR Statement

    I just can't get this to be excepted. Brain blank If I19 = "E" and V19 = "U" or "P" then U19 otherwise 0 =IF(AND($I19="E",IF(OR($V19="U",$V19="P"),$U19,0) Thanks DK
  9. C

    Need to add a criteria to a loop formula[SOLVED]

    Thanks Debraj [SOLVED]
  10. C

    Formula seems to work and then get #Value error

    The formula is held within a defined name so that I can amend it if needed as it is used across many different sheets. The ! mark allows the formula to be used across different sheets. Thats my understanding? DK
  11. C

    Formula seems to work and then get #Value error

    This formula seems to work ok and then suddenly kicks up #value error. As this is a key formula in my many sheets I would appreciate any help. Thanks DK...
  12. C

    Need to add a criteria to a loop formula[SOLVED]

    This code currently runs fine. It goes through many sheets. Many of these sheets might not have any information to extract. In order to exclude them and speed process up I want the sheet to be skipped if DH7 in each sheet is not greater than 0. Thanks DK. Sub FloatExtract() Dim Sh As...
  13. C

    Too Many If Statements in formula?

    If I add a code into I40 then the #N/A goes away. When I40 is blank get #N/A
  14. C

    Too Many If Statements in formula?

    Faseeh /Luke Thanks for this guys. Luke I can see that this should work. I've copied across but get a #N/A result if field. Any thoughts. DK.
  15. C

    Too Many If Statements in formula?

    Hi Faseeh Not quite. If AT40 = 1 then this takes precedence and V40 become "P" Your point 1 correct. Your point 2 correct - if this matches up the F/I/B/O to be F/U/A/A If I40 is blank - V40 is blank
  16. C

    Too Many If Statements in formula?

    This looks exactly the same formula above? Still not getting result. With P1 in I40 and date in J40 getting "..." in V40? DK
  17. C

    Too Many If Statements in formula?

    Hi Faseeh I can't get your solution to work. I copied into my real sheet. Then I opened up your file and that doesn't give the expected results? I40 = F / J40 no date / V40 should be "F"? DK.
  18. C

    Too Many If Statements in formula?

    Hi Somendra Thanks for this. I do need the solution to be in a single formula. I understand how to get the basic "I"/"O" etc to provide the required result the bit that I am struggling with is getting the "S1" & "P1" to work with TODAY() and then provide the correct answer depending on the...
  19. C

    Too Many If Statements in formula?

    Hi Roseus Thanks for this. How would the need for the > Today() condition fit into this. (2nd last line on my listing). DK
  20. C

    Too Many If Statements in formula?

    I have the code below - which is not working. I think I have too many If statements. This formula is in V40. I also need to add in one further condition...
  21. C

    Faster code than looping code

    It's saying that there is a syntax error on this line? Rng.AutoFilter Field:=1, Criteria1:"<>0"
  22. C

    Faster code than looping code

    Thanks for this I'll try the filtering. Have seen some code around that seems to select all the lines with "0" and then just deletes 1 time. As you say I see what else might come back. DK
  23. C

    Faster code than looping code

    I have this code that does the job but can be slow as it's looping. Goes through 4000 lines. Is there a faster solution - sure there is? Sub HideBudgetRows() Dim cel As Range Dim rng As Range Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Set rng =...
  24. C

    Use list of worksheet names to set UserInterfaceOnly on Opening

    The code below sets the UserInterfaceOnly for Sheet13 when the workbook open. I have many many sheets that need to be set - some with different passwords. Can I use a listing of worksheet names somewhere that can then be used in an array or something rather than having to type them...
  25. C

    Why when line gets inserted does it then get hidden

    Hi Luke Not sure what you mean by your first line. I do have 1 row that is hidden which is the line that gets copied to be inserted - its within the area of Row 95:100 I am freezing panes at row 8. DK
Back
Top