Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Downloads
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- P-Y Curve function
- Latex Maths Text in Excel
- Solving higher order polynomials
- Filling Blanks with Go To-Special (and local help rant)
Recent Comments

Z on Downloads py_xlCBA – Sup… on py_xlCBA update 
dougaj4 on Downloads 
Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC…
Tag Archives: Countif function
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