-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
sits
-
T
Radomised Seater Chart
Hi everyone, looking for a radomised seating chart where everyone moves tables - 20 people - 5 tables - 5 rotations No one sits together more than once. But everyone gets to see each other once. Is this possible? Thanks- tassietiger
- Thread
- chart radomised seater sits tables
- Replies: 2
- Forum: Excel Questions
-
T
Formula Help
Hello, Hoping someone can help me understand the logic in this formula...what cells is it referencing? If I want to move the information from one column to another how would I get it to reference this column instead. =IF(A2="SHOES",AC2,IF(A2="Lucky...- tasha23xx
- Thread
- bring column formula reference sits
- Replies: 0
- Forum: Excel Questions
-
S
Static Randomisation Probability
Hi, I have the following formula working out a random Yes / No based on some probability. In B23 I have the following code (it sits in a table) =IF(A23="","",INDEX($A$2:$A$3,COUNTIF($C$2:$C$3,"<="&RAND())+1)) However as more data gets added below A23, it recalculates. What I'm looking for...- Steven101
- Thread
- b23 code probability sits table
- Replies: 1
- Forum: Excel Questions
-
A
Help with transferring cell values to new worksheets based on certain cell value.
Hi folks! So I have a workbook where I need certain data to copy into a relevant worksheet based on a scoring system I've set up. The scoring system breaks down as follows and the names of the worksheets are Core, Invest, Opportunistic & Challenge. The name of the account sits (account...- AdamBurgess7
- Thread
- account cell score sits worksheet
- Replies: 0
- Forum: Excel Questions
