View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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?