Your Ad Here Your Ad Here
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Excel

  1. #1
    blank BT Rep: +1
    Join Date
    Oct 2003
    Posts
    1,068
    Prob the wrong place to put this but never mind.

    Anyone good at excel? Need some help

    Question1) A1(cell/row) is a date eg 07/07/2004

    how can i add a forumula to this cell so every 6 (so next one will be A7) down the date will increase by a day? Obviously =sum(a1+1) is a7 but how can i make it automatically do it?

    Question2) How can i minimise a section? Each day on my table has various things. How can i minimise a day into one row. eg clicking the plus/minus sign on the side. I have seen it on other book but cant figure out how it was done.
    Shut that cuntís mouth or Iíll come over there and fuckstart her head.

  2. Software & Hardware   -   #2
    Storm's Avatar Poster BT Rep: +3
    Join Date
    Apr 2003
    Location
    crazy skiing monkey
    Posts
    1,350
    A1)what do you mean by automatically? you not having to manually enter the formula (or copy pasting?)

    if so, i dont think its possible
    great FTP site for awesome quality video clips
    yeah, you have to sign up, but its worth it

  3. Software & Hardware   -   #3
    Barbarossa's Avatar mostly harmless
    Join Date
    Jun 2002
    Location
    Over here!
    Posts
    19,631
    OK, I don't know, but...

    Start off like this:


            A
    1    07/07/2004
    2    =a1
    3    =a2
    4    =a3
    5    =a4
    6    =a5
    7    =a1+1
    Now highlight rows 2 to 6 and change the text colour to white (so you won't see them!

    Then select lines 2 to 7 and copy them however many times you want.

    To do the filtering, in the data menu set autofiltering on, then you will be able to select a date, the sheet will then only show the rows where that date is in column A.

    I don't know if this is what you want, but hope I've been of some help!

  4. Software & Hardware   -   #4
    Storm's Avatar Poster BT Rep: +3
    Join Date
    Apr 2003
    Location
    crazy skiing monkey
    Posts
    1,350
    whats the use of inserting that text into cells A2-A6??
    great FTP site for awesome quality video clips
    yeah, you have to sign up, but its worth it

  5. Software & Hardware   -   #5
    blank BT Rep: +1
    Join Date
    Oct 2003
    Posts
    1,068
    autofiltering is good thanks.

    other not so.

    what i am looking for is something like this

    a1 is 07/07/04, i want a7 to be 08/07/04 and so on.

    but instead of me having to type them all in manually. i wanted to write a formula in a1. maybe give up
    Shut that cuntís mouth or Iíll come over there and fuckstart her head.

  6. Software & Hardware   -   #6
    Turkishjade's Avatar Gunny
    Join Date
    Jan 2004
    Location
    New York, NY
    Posts
    111
    Don't know if you gave up already, but based on you wanting every sixth row to add one to the date, you could do this:

    A1 would be: =7/7/2004
    A2...A999 would be: =A1+INT(ROW()/6)

    Each cell would have to reference A1. You would have to format the whole column as a date. Hope that helped.

  7. Software & Hardware   -   #7
    blank BT Rep: +1
    Join Date
    Oct 2003
    Posts
    1,068
    Originally posted by Turkishjade@7 July 2004 - 14:28
    Don't know if you gave up already, but based on you wanting every sixth row to add one to the date, you could do this:

    A1 would be: =7/7/2004
    A2...A999 would be: =A1+INT(ROW()/6)

    Each cell would have to reference A1. You would have to format the whole column as a date. Hope that helped.
    doesnt seem to work.

    a1 formula is 07/07/04

    then am i highlighting everything from a2 down and copying A1+INT(ROW()/6) into the formula bar?
    Shut that cuntís mouth or Iíll come over there and fuckstart her head.

  8. Software & Hardware   -   #8
    Barbarossa's Avatar mostly harmless
    Join Date
    Jun 2002
    Location
    Over here!
    Posts
    19,631
    Type the date into a1

    Type =A$1+INT(ROW()/7) into a2

    Then select a2 and press ctrl + c

    The select the rest of column a down ad inifinitum and press ctrl + v...

  9. Software & Hardware   -   #9
    blank BT Rep: +1
    Join Date
    Oct 2003
    Posts
    1,068
    Originally posted by barbarossa@7 July 2004 - 16:20
    Type the date into a1

    Type =A$1+INT(ROW()/7) into a2

    Then select a2 and press ctrl + c

    The select the rest of column a down ad inifinitum and press ctrl + v...
    ok that kinda works but puts the same date for 7 cells before changing to the next date for 7 cells...i want it just to appear in every 7th..
    Last edited by Barbarossa; 04-03-2007 at 11:21 AM.
    Shut that cuntís mouth or Iíll come over there and fuckstart her head.

  10. Software & Hardware   -   #10
    Barbarossa's Avatar mostly harmless
    Join Date
    Jun 2002
    Location
    Over here!
    Posts
    19,631
    Oh well...

Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •