I have a two-part question. I have been using this phrase frequency Excel macro for years. It has two downsides:

1. It doesn't include numbers in the output.
2. If I wanted the output to exclude results that contained full phrases like "to, as, of, is, for, and, the"... is that possible? For example, if a 3-word phrase was 'for excel forum', because it contained the full phrase 'for', this 3-word value would not show up in the output (it would be excluded from the results because it contained the phrase 'for').

In the attached, you can see keyword phrases in column A. When the Button is clicked, it creates 1-word, 2-word, 3-word and 4-word phrases based on the keyword list density in column A.

Frequency Macro.xlsm