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

Growing Count selection

P

Pofski

Member
Hi,


I was looking for a way to have a growing list where a new count was added everytime that the date changes.


If i remember correctly chandoo has a tutorial about how to do something similar, but i can't seem to find it.

I have a report that's updated on a irregular base, and i would like to make it so that whenever the date is more then the previous there's an automatic count of a certain result in a colomn, and that total is added to a growing list.

This way i can have an overview of what the results would be at the end of the year.


Thank you in advance


Sincerely,


Pofski
 
Pofski


Have a read of:

http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

&

http://chandoo.org/wp/2012/09/17/offset-formula-explained/
 
Ok, basicly this is what i am trying to do:


https://docs.google.com/file/d/0B0naOkYo4pCmNERlVVYzV3ZoQ0k/edit?usp=sharing


now, if you change the date, the list on the left should compare to see if the date is higher then the previous one, and if so, take a stamp of it.

The way it works now is that if i change the date, i have to do it twice before the stamp is made.


The different colours are different ways of formulating that i tried.

Does anybody have a better idea of how to get where i'm going, cauze i'm starting to hit a block :/


Also, i try to do it without macro's.


Thank you in advance.


Oh, and Hui, thank you for your help already. The links where exactly the ones i was looking for.


Sincerely
 
Appearantly, if you put anything else in any other cell after changing the date, then it works. So it seems to be a matter of refresh.

But is there any way to force the refresh after the date is changed?
 
Hi, Pofski!

Your formulas in column A work fine if you enable iterative calculation (File, Options, Formulas, Enable Iterative Calculation).

Please note that this setting is for the instance of Excel and not for certain file, so you should remember to turn it off after closing the workbook and turning on when opening it, and taking care of another open workbooks -which I discourage you to do so-).

The easiest way is to add a macro at open time and at close time for the related workbook, but as you decided to do it without macros you'll have to do it manually.

Regards!
 
Hey :)


Just wanted to let you guys know that i used the following formula in the first column (in cell A15)

=IF(AND(A14<>"";A14<$D$1);IF(A15="";$D$1;A15);"")


Then dragged this down for about 100 cells so that it would grow each time there is a new time stamp.


Sincerely
 
Hi, Pofski!

Everything fine for the information, but how did you managed to make it work without enabling iterative calculation? Because if we consider your cell A15, the formula in it refers to itself.

Am I missing something?

Regards!
 
You must log in or register to reply here.
Back
Top