Excel

[hungrylilboy]

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.

[Storm]

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

[Barbarossa]

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!

[Storm]

whats the use of inserting that text into cells A2-A6??

[hungrylilboy]

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

[Turkishjade]

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.

[hungrylilboy]

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?

[Barbarossa]

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

[hungrylilboy]

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

[Barbarossa]

Oh well...