Hey guys, I have written a quick spreadsheet that does a character
frequency analysis on a given ciphertext string.
I have a question on improving the functionality:
Q: Is there a way to print out the ten most frequent bigrams (two
letter combinations) and trigrams (three letter combinations) with a
formula or VBscript?
I have attached the file for your review.
Thank you in advance for your assistance.
-JJ
+-------------------------------------------------------------------+
|Filename: Cryptanalysis Worksheet.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=5083 |
+-------------------------------------------------------------------+
--
jjunginger
------------------------------------------------------------------------
jjunginger's Profile:
http://www.excelforum.com/member.php...o&userid=36703
View this thread:
http://www.excelforum.com/showthread...hreadid=564366