Posts Tagged ‘excel’

Excel Formulas

12
responses
by
on
November 2nd, 2005
in
Cool Scripts

Excel Formulas: I use Excel almost everyday to produce numbers for the higher ups and the innovation of Excel programmers never ceases to amaze me. Here is a formula to count the total number of times a certain character shows up in a string. High level programming has me so caught up in functions that this simple trick evaded me completely. Count = LEN(B1)-LEN(SUBSTITUTE(SUBSTITUTE(B1,”B”,””),”b”,””))

[Continue Reading...]



Obviously Powered by WordPress. © 2003-2013

css.php