Hi, I started to program an algorithm in excel, but I need to have confirmation if I am doing it right. Situation as following: I have 2 lists of names, which I want to match to each other as a "meeting generator".That means, that each person should meet up with the other once, and restart when the matching list is finished. Here, the if function is getting very long, as I need to include every cell. Is there a shorter way to do it? Helpful answers are highly appreciated
Create a list of numbers and list of names.
For example:
And then use =VLOOKUP(RANDBETWEEN(1,3), range_names, 2, FALSE)
1 John 2 Jane 3 Charlie
(where range_namse is above range of names i.e. H1:I3
Never use Merged Cells in Excel
Hey, thanks for the answer. It should look like "Mathew" meets "Jon" from those two lists; without numbers.
Upload example workbook
I Believe I attached it now. Ideally, it should be:
example:
Row a: Person 1
Row b: meets/ doesn't meet
Row c: Person 2
Thanks in advance
Is this what you mean?
Remember this is volatile and duplicates are allowed in each column.
That is the list generated can have the same name more than once in either column.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Cool, thank you, this is a new learning for me with the index function. Just that I understand it right: With the index number, you returned the value to the reference, then, you randomised it. Than the meet up function in if-function. However, if the meeting is once a week, how can I repeat the meeting, without having the case of that the same people meet up again before the whole name list is through?
THANKS alot!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks