Forum Discussion
I need help with generating a formula on excel
I need a formula to randomly generate a number between 1 and 5 but excluding the number in the cell before it. For example, if A1 has =RANDBETWEEN(1,5) and the number is 5 then I need a formula for B...
It still doesn't work.
I want it to look something like this but with five collums. I'm also not given the formulas for this either.
A couple of things
1. you should have said that in the first place as the thing I did has 5 columns and fits what you asked for.
2. upload the file not a screenshot.
1. you should have said that in the first place as the thing I did has 5 columns and fits what you asked for.
2. upload the file not a screenshot.
Sorry
I can't upload the excel file, but I converted it into a google sheets
https://docs.google.com/spreadsheets/d/1BcYsNXAaz1b2-GPo11EHudmAoJwGu2Xb/edit?usp=drive_web&ouid=108422099674792179335&rtpof=true
- did you try opening text editor?
I don't use Google sheetsIt still doesn't work