• 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. B

    Send email when a Cell value is less than a number

    Dear All, Can you please advise if an email can be sent automatically to a person; if a call value reaches below a limit. can this be possible Best Regards, Brijesh Keni
  2. B

    IF Statement Logical Test

    Hi All, Can you please advise If text can be added in the logical test. IF(D1="Group Leader", Yes, No) But when D1 is Group Leader it displays the result as No Please advise. Best Regards, Brijesh Keni
  3. B

    Compare a value with series of cells and display output

    Hi All, I need to compare a value in a cell; say 'D4' with series of numbers; say 'F2:F9'. lets say the values in each cell from F2 to F9 are: F2 - 2 F3 - 4 F4 - 5 F5 - 6 F6 - 7 F7 - 8 F8 - 9 F9 - 10 If D4=6; then i would need a formula which would compare all values from F2 to F9...
  4. B

    Conbining Two worksheet_change macros in one sheet

    Dear All, I was trying to use two worksheet_change macros in one sheet further to which i was getting error. Can you please advise what could be wrong? the macros are defined below. Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range Set rng = Target.Parent.Range("E48")...
  5. B

    Behavior of rows or cells based on the value on one cell

    Hi All, Am new to this forum and was enlightened to observe such valuable information flowing. I am actually trying to adapt the behavior of group of cells or rows depending on the value of one cell. Just to illustrate it: I have created a drop down list on 'Cell 1' (from 1 to 10)...
Back
Top