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”,””))
An avid fan of business, education, technology and finance. I lead a lean, highly focussed and capable team of Java Back End developers and Front End developers through a maze of complex software wizardry to fulfill the web maintenance needs of a large chemical manufacturer. As per Myers-Briggs Personality Types, I am an ESTJ. I pride in a project completed on time and according to plan. My hobbies include all kinds of technology, anything that I can taste and anything that goes fast or flies in the air. I like to read business books and comics in my spare time.
Obviously Powered by WordPress. © 2003-2013
Excel is twisted art in its own right.
Anyone who can understand what that means has either too much time on their hands or an unhealthy interest in masochistic scripting techniques.
Excel Formulas act like a cross between perl and sql with a bit of basic on the side.
I use Excel a lot and am often surprised by simple, elegant solutions like this one. Thanks for sharing!
You just gave me a geek-gasm. Excel is my favorite favorite obsession.
Use a shellskript instead and you can call yourself a geek. Excel is for losers and managers who do not understand what really matters 😈
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
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.
excel is so complicated!! i’m only 12 so i have absolutely no idea what this is about. =S
haha
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!!!!