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

    Twist on Timestamps.

    Luke thanks very much for your help, could you advise me if I have the events of 1 or 0 in AE 8 and AE 9 , and need timestamps in AC12 and AC13 and then every 16 cells down IE: AE 24 and AE 25 being the next and AC28 and AC29 for timestamps related to those becoming 1. Also is there a way to...
  2. I

    Twist on Timestamps.

    Ok, will try it out in the office tomorrow! Is there anyway I can set the event cells to be like 1 every 6 cells, IE a3,a9,a15
  3. I

    copy only cells which contain something

    Try using arrays. Make an array in another column say B or even another sheet, this array should just start with =if(a1=0,0,1) (considering your inputs as above are in row a starting from column 1) then in another array say column C, put C1 as =if(B1=0,0,b1)then in c2 put...
  4. I

    Twist on Timestamps.

    I understand timestamps has been discussed before and I have gone through IE: (http://chandoo.org/wp/2009/01/08/timestamps-excel-formula-help/). However I have a twist on what I am trying to achieve. I want to create a static timestamp as a formula without VBA that is caused by another event...
Back
Top