Loved this solution, but It's even simpler now with the xlookup function as you can specify what to do with missing items, such as insert blanks in the formula. I'd probably also use randbetween 0-1 to make it less likely to get duplicates. Thank you for sharing.
How can I add titles? Example puzzle Clue 1: crypotgramed clue Clue 2: cryptogrammed clue Clue 3: cryptogrammed clue Answer: cryptogrammed answer Would it just be a matter of adding the titles in MS Word and using the same key for all three clues? How can I add a box for the user to keep track of the key ( so they can fill in the letters they have figured out)? What is the best way to eliminate duplicates? Higher the number ( instead of 1000, make it 2000)?
![How to Perform Cryptography in Excel. [HD]](/img/1.gif)
Thanks so much! My daughter wanted a puzzle like this and helped me create it much faster. The tutorial was very easy to follow.
Thank you so much. I used your tutorial in Google Sheets, had to make a couple of changes, but got it to work. Great video.
Loved this solution, but It's even simpler now with the xlookup function as you can specify what to do with missing items, such as insert blanks in the formula. I'd probably also use randbetween 0-1 to make it less likely to get duplicates. Thank you for sharing.
Great video. Thank you very much.
Very interesting. How do you add the overline over every letter?
thanks
How can I add titles?
Example puzzle
Clue 1: crypotgramed clue
Clue 2: cryptogrammed clue
Clue 3: cryptogrammed clue
Answer: cryptogrammed answer
Would it just be a matter of adding the titles in MS Word and using the same key for all three clues?
How can I add a box for the user to keep track of the key ( so they can fill in the letters they have figured out)?
What is the best way to eliminate duplicates? Higher the number ( instead of 1000, make it 2000)?