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

    Deleting in excel

    thats great thankyou! now how do i get all the rows to just be called 1,2,3,4 etc because at the mo theyre 3,9,15,21 (every 6) so it wont let me copy the data?
  2. C

    Deleting in excel

    Hi i have a large set of data but only want every 6th value. How do i delete the other 5 values for the whole data without deleting them five at a time which is taking ageesss?! also how do i then move the wanted values up so there arent lots of five space gaps? Thanks Carrie
  3. C

    If function excel

    Yeah its to two decimals so just gives 0.0 but ive tried the max thing and that works thanks :)
  4. C

    If function excel

    Hi I am trying to do an if function to say that if the value is less than 0 make it 0 and if its more than 0 keep it as what it is so ive typed =IF(D52<0,0,D52) and the original value of D52 was 0.2 so it should stay as 0.2 and excel says the function answer is 0.2 but 0 comes up in the...
Back
Top