Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Alternative iterative solvers
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Automating chart scale limits - update
- Latex Maths Text in Excel
- 3D Frames, axes and stiffness matrices
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Taming Symbols in Excel
Recent Comments
Tag Archives: Count 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