Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- XLDennis, the MSDN Library, and VBA rant
- Using LINEST for non-linear curve fitting
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 4: Continuous Beam Analysis
- Downloads
- Daily Download 5: Frame Analysis
- Cubic Splines
- Writing Arrays to the worksheet - VBA function
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
Recent Comments
Tag Archives: Extract unique words
Counting words in a list and dictionary links
This post presents two methods for extracting all the different words from a list and counting the number of occurrences of each word. The spreadsheet, including full open-source VBA code, can be downloaded from: CountWords.zip As an example, I have … Continue reading
Posted in Excel, UDFs, VBA
Tagged Count words, Countif function, Excel, Extract unique words, scripting dictionaries, UDF, Unique function, VBA
Leave a comment