How does one create a formula using a sequence to infinity? Example: I have data that needs to be split into days of the week, so there has to be a sequence of 7 continuing to infinity.
Thanks
DeKay
How does one create a formula using a sequence to infinity? Example: I have data that needs to be split into days of the week, so there has to be a sequence of 7 continuing to infinity.
Thanks
DeKay
Re: sequence formula to infinity
I don't work with these types of formulas but I think from memory the ERF or ERFC function are used.
Sorry I can't be of more help.
Re: sequence formula to infinity
Can you be a little more explicit about your needs.
If you have an existing data set, then you probably can use WEEKDAY() -- (perhaps in combination with SUMIF() or SUMPRODUCT() ... or a Pivot Table) -- to extract data for specific weekdays or sets of weekdays.
Without understanding your dataset and output requirements it's a bit hard to help accurately or efficiently.
AND ... Welcome to OzGrid. Glad to have you here.
Re: sequence formula to infinity
I may be over-simplifying here but how about this scheme?
1. Write in the first seven days - say in cells A1 thru A7
2. In cell A8, write the formula to refer to A1 (=A1)
3. The formula in A8 may be copied down as many times as desired (within a total count of 65536, of course.)
HTH
m
Re: sequence formula to infinity
What you describe should work. You also could use MOD(ROW()+n,7) -- where n is an integer from 0 to 6 to get your formulas in synch with your day count.
Lot's of ways to do this if I understand your need correctly.
Your also possibly could do different weekdays in columns 1-7 and copy these formulas down incrementing the formula by ROW() number.
Don’t have an account yet? Register yourself now and be a part of our community!