Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
each 15th row
Hi,
In column A i have a data. I would like to copy down (B1:B60) formula and find every 15th row previous one, I mean B15, B30, B45,etc...and then just filter each. Thanks Reniek |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
each 15th row
Hi
as stated in your other post: Not really sure what you're trying to do -- Regards Frank Kabel Frankfurt, Germany "Reniek" schrieb im Newsbeitrag ... Hi, In column A i have a data. I would like to copy down (B1:B60) formula and find every 15th row previous one, I mean B15, B30, B45,etc...and then just filter each. Thanks Reniek |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
each 15th row
Reniek
=MOD(ROW(),15) Then filter to show zeros -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Reniek" wrote in message ... Hi, In column A i have a data. I would like to copy down (B1:B60) formula and find every 15th row previous one, I mean B15, B30, B45,etc...and then just filter each. Thanks Reniek |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
each 15th row
try this
Enter the following formula in Sheet2, beginning with cell A1 and copying down & across: =INDIRECT("Sheet1!A"&ROW(Sheet1!A1)+(15*(ROW()-1))) =INDIRECT("A"&ROW(A1)+(15*(ROW()-1))) Remember to change the Column from A to whatever, when you copy to another column. "Dick Kusleika" wrote in message ... Reniek =MOD(ROW(),15) Then filter to show zeros -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Reniek" wrote in message ... Hi, In column A i have a data. I would like to copy down (B1:B60) formula and find every 15th row previous one, I mean B15, B30, B45,etc...and then just filter each. Thanks Reniek |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting for 15th and last day of the month | Excel Worksheet Functions | |||
Updating a Value every 15th and 1st | Excel Discussion (Misc queries) | |||
Date if before or after 15th of month | Excel Worksheet Functions | |||
15th of prior month | Excel Worksheet Functions | |||
every 15th row - formula | Excel Programming |