Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
In excel can you have a number and a formula in the same cell without a conflict?
I have a sheet that looks like this
1=2
2=3
3=4
1=1
2=2
3=3
1=4
2=1
3=2.......
The first number and equal sign must stay but the last number will go in order 1-4. Every month the last number must be rearranged so I have 30 changes per month. I would like to just be able to add a formula that would allow me to change the first days number and then all will change. So I need something like this:
1=1
2=(a1+1)
3=(a2+1)
1=(a3+1)
2=(a1)
3=(a1+1)
1 Answer
- IXL@XLLv 78 years agoFavorite Answer
In cell A1 enter 1 to 3 as as often as is required
In B1 enter =IF(MOD(ROWS($1:2),4)=0, 4,MOD(ROWS($1:2),4))
Copy down to match column A.
Select cell containing 1 (except first instance) and corresponding result, right click, select Insert and select Shift cells down. Repeat for each row containing 1
