post-page

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”,”"))

heading
12
Responses

 

Comments

  1. Tom (14 comments.) says:

    Excel is twisted art in its own right.

  2. David Russell (32 comments.) says:

    Anyone who can understand what that means has either too much time on their hands or an unhealthy interest in masochistic scripting techniques.

  3. Kevin says:

    Excel Formulas act like a cross between perl and sql with a bit of basic on the side.

  4. Darren (1 comments.) says:

    I use Excel a lot and am often surprised by simple, elegant solutions like this one. Thanks for sharing!

  5. Rori (2 comments.) says:

    You just gave me a geek-gasm. Excel is my favorite favorite obsession.

  6. Sebbi (3 comments.) says:

    Use a shellskript instead and you can call yourself a geek. Excel is for losers and managers who do not understand what really matters :twisted:

  7. Steph Rose (1 comments.) says:

    I use Excel everyday at work and sometimes at home too. At work I mostly use it for our expense reports, record keeping, tracking PMI’s, providing our customers with up-to-date status of their equipment, employee time sheets and much more. There are so many things we can use Excel that it is hard to remember them all. Sometimes we use it to create estimates or invoices to email to our customers and prospective customers. I have learned a lot about Excel after using it for more than nine years now. I

  8. Kristen says:

    I almost got fired from my job today because I didn’t know how to do formulas. I know it’s really important at my job, however, math has never been a strong point for me. If anyone wants to comment and give me some advice I would appreciate it. Thanks. Good luck to everyone trying to figure Excel out.

  9. marius says:

    does anybody know how to do some queries in excel… find the line (j) where the value of the B colon is “FIND” and then access a field in colon C: Cj

    thanx,

    marius

  10. Monique says:

    excel is so complicated!! i’m only 12 so i have absolutely no idea what this is about. =S

  11. Monique says:

    haha

  12. cs.coleman says:

    I almost got fired for using Excel too much. In my first review on my current job, I was written up for using Excel too much, and hinted that I better stop using it so much, or else!!!!



Obviously Powered by WordPress. © 2003-2013

page counter
css.php