Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Downloads
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Daily Download 2: SLS design of reinforced concrete sections ...
- Contour plots with Excel and Matplotlib
- Retrieving unique values from a range or array ...
- Downloads by category
- Latex Maths Text in Excel
Recent Comments

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… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Installing Adobe Reader non-DC… 
Z on Downloads 
Z on Daily Download 8: Drawing in… py_ConBeamU and Stra… on py_ConBeamU and Strand7 check… 
dougaj4 on Daily Download 8: Drawing in… 
Z on Daily Download 8: Drawing in…
Tag Archives: Count distinct
Counting unique values from a range or array
About this time last year, I posted a User Defined Function (UDF) that would return a list of unique items from a list: https://newtonexcelbach.wordpress.com/2012/01/31/retrieving-unique-values-from-a-range-or-array/ That post has recently received a few comments, and coincidentally Colin Legg at RAD Excel has … Continue reading