Search results

Just wondering if someone could provide any help with this. Thanks Josedv

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

Faseeh, Not yet as I am not at work today but will check it tomorrow. Thanks for your help. Josedv

Amritansh, How would you adjust the formula is the dates are sorted from oldest to newest? Regarding the empty cells, I don't want to do anything specific with these cells, however I will keep adding information to the data base over the time. Thanks again, Josedv

Kaushik, Your the result of your formula is the newest date from all the group of dates. What I need is the next future date? Thanks again, Josedv

Amritansh, I can certainly change the date format to the american one. One more question, on my example above the dates are sorted from the newest to the oldest one. How can I change the formula if they are sorted from oldest to newest?? Also I need to program the formula for a range of 9999...

Hi Amritansh, Thanks. I have tried your formula and it doesn't work with the cells formatted as "date". If I replace the dates with numbers instead it works fine. Any ideas? The date format I am using is dd/mm/yyyy Pd. Kaushik- Thanks for your suggestion. It works fine but I prefer not...

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

Narayan, Perfect! That does exactly what I wanted! Thank you all for your help, Josedv

Hi SirJB7, Ok let me try and answer your questions: A) yes B) what I wrote was just an example, the blank cells (and the number of blank cells in the columm) depends of the value I choose on a pivot table C) they are updated by changing the selection on the pivot table D) the numbers are...

Hi SirJB7, Thanks for the info. The thing is that I want the blank cells to remain empty as the rows wth blanks will be hidden later on, hence "fillcell" sort of formulas is not an option. All the other values will change depending on the previous non blank cell. They should always show the...

Hi all, Thanks for the help. Unfortunately Niting and Debraj's seems not to work for some reason. Sajan, your formula is close to work but the only problem is that after the blank cell starts the sequence again and what I want is to continue the sequence from the previous non blank cell +...

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