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

    VBA to automatically adjust charts axis based on cell values

    Hi there, I've got various different charts on a sheet. I am looking for a Macro to automatically adjust the maximum and minimum scale of the axis as well as the point where the horizontal axis crosses. The macro I am working with is (just for two graphs for the sake of this example) Sub...
  2. J

    Find closest date in the past (the date is concatenated)

    Hello there, I am looking for some help. I have a data base on sheet1 made of 3 columns and 9999 rows. It looks as follows: A. B. C. 1. John Lewis. 13/10/12. Madrid. 2. John Lewis. 13/10/12. Paris...
  3. J

    Sum previous non blank cell in a column

    Hi there, In a column where some cells are filled with numbers and others are blank, I need to find a formula for each cell to find the first non blank cell above it and sum +1 to the value of the cell. I've been trying with formulas like ISBLANK and IF but with no success. Any help will be...
Back
Top