Good morning all! I am new to this forum and I hope that someone can help me. I have a dataset made in this way date animals status 1/03/2015 30000 full 1/04/2015 29950 full 1/04/2015 29905 full 1/05/2015 28880 full 1/06/2015 28870 full . . . . . . . . . 2/20/2015 0 empty 2/21/2015 0 empty 2/22/2015 0 empty . . . . . . 2/28/2015 30000 full ecc.. Let me explain my problem, I have to number the day each time the shed is filled with animals (and I need to stop the count when the shed is empty), but I really do not know how to do this. the file is made of several rounds (made in the same way) I've tried some do loop including the "if first." condition, but did not work properly. I tried also some macros, but I'm not so skilled. the final dataset should look like this: date animals status day round 1/03/2015 30000 full 1 1 1/04/2015 29950 full 2 1 1/04/2015 29905 full 3 1 1/05/2015 28880 full 4 1 1/06/2015 28870 full 5 1 . . . . . . . . . 2/20/2015 0 empty . . 2/21/2015 0 empty . . 2/22/2015 0 empty . . . . . . . . 2/28/2015 30000 full 1 2 3/01/2015 29999 full 2 2 3/02/2015 29999 full 3 2 ecc..
... View more
