Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,171
- Office Version
- 365
- 2019
- Platform
- Windows
Good morning. I have a list of Presidents that I have have on Sheet2 i.e.
WASHINGTON
LINCOLN
KENNEDY
On sheet1 I have scrambled the presidents i.e for WASHINGTON I could have TNSHWOINGA or GNOWNIHSA or WISOTGHNNA exc. Is there a way to descramble the the words on Sheet1 with a function that will match the list on Sheet2? So for instance if I had TNSHWOINGA it would bring back WASHINGTON. All of the names will be distinct. Thanks in advance
WASHINGTON
LINCOLN
KENNEDY
On sheet1 I have scrambled the presidents i.e for WASHINGTON I could have TNSHWOINGA or GNOWNIHSA or WISOTGHNNA exc. Is there a way to descramble the the words on Sheet1 with a function that will match the list on Sheet2? So for instance if I had TNSHWOINGA it would bring back WASHINGTON. All of the names will be distinct. Thanks in advance