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
We will be implementing some important changes during 25th and 26th May 2024 which may result in an outage period of the website. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
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!