Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi All
I am totally out my depth but I need to Learn.In b11 on a worksheet is the following. =INDIRECT("'date details'!"&ADDRESS(3,(INT(ROW()/80)+3))) returns the following results the date that is in cell c3 on worksheet "date details "appears b11 when the above formula is placed in it the date that is in cell d3 on worksheet "date details" appears B91when the above formula is placed in it the date that is in cell E3 on worksheet "date details" appears B171when the above formula is placed in it and on and on whenever you pace that formula How is the 80 row sequence worked out and how is it relative to the intial. cell of B11 Remember I'm new to this Best Stew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please explain formula to me | Excel Worksheet Functions | |||
Please explain function/formula | Excel Worksheet Functions | |||
Could any one Explain this Formula | Excel Worksheet Functions | |||
Let me see if I can explain this... | Excel Worksheet Functions | |||
Please Explain Formula | Excel Worksheet Functions |