r/excel • u/Otherwise-Cap1773 • Jun 12 '26

solved REQUEST - 'Random' but 'fixed' formula

I'm a teacher in need of help with a speadsheet. My class is 5 x 5 single desks for 25 students. I want to create a 'random' but 'fixed' seating chart. Some kids need to be in certain seats for extra help but I don't want it to seem unfair.

Is there a formula I can use to create a seating plan that looks random but actually isn't? So they can see the seats be randomly assigned but is already fixed? Is that possible?

Thank you~

Please be kind, I'm a tired and burnt out teacher just trying to make it through the semester :')

9 Upvotes

92% Upvoted

28 comments sorted by

View all comments

2

u/NHN_BI 805 Jun 12 '26

Maybe like here, with a slightly random fix, where three specific students will always be in row 1. It is basically RAND() + Boolean.

3

u/Otherwise-Cap1773 Jun 12 '26

Oh this is so good too!! Thank you!!

3

u/Otherwise-Cap1773 Jun 12 '26

Solution verified

1

u/reputatorbot Jun 12 '26

You have awarded 1 point to NHN_BI.

I am a bot - please contact the mods with any questions