Returning every 7th row of a column
Hi,
Put the formula in a cell and it will return the first value. You have to
drag the formula down to get the next values
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"bondjel" wrote:
I should have said the formula did NOT repeat by looping thru the whole
column of dates
"bondjel" wrote:
Unless I did something wrong, I used this formula and it returned the 1st
date properly but did repeat by looping thru the whole column of dates.
"Mike H" wrote:
Hi,
Assuming the date are in Col A try this formula dragged down
=INDEX(A:A,(ROW(A1)-1)*6+1)
Now this assumes the data start in row 1. If it's another row then adjust
the last 1 in the formula to that row
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"bondjel" wrote:
I have a row of 1836 consecutive dates in a column and I want a new column
with only every 7th row's date (the date beginning each week). How do I get
Excel to do this?
|