Darren_workforce
Board Regular
- Joined
- Oct 13, 2022
- Messages
- 146
- Office Version
- 365
- Platform
- Windows
I have a 5x5 grid that uses the formula below. I was curious if it's possible to adjust the formula so that the center cell of the 5x5 is not affected while still allowing all remaining cells to follow the same formula. (F79 is just a random number based on prior weekly data.)
=WRAPCOLS(TAKE(SORTBY(SEQUENCE($F$79),RANDARRAY($F$79)),25),5)
Thank you in advance!!
=WRAPCOLS(TAKE(SORTBY(SEQUENCE($F$79),RANDARRAY($F$79)),25),5)
Thank you in advance!!