Today's quick blog article will talk about a favorite formula string I use time and time again.  If you read my blog, you know I use Excel as my tool of choice for data manipulation. My challenge today was to find and match emails in two columns.  What I wanted to do was weed out emails that were duplicated in both columns.   I used a formula and will explain it below. Let's use the following list as my example: Column A Column B Column C This email address is being protected from spambots. You need JavaScript enabled to view it.  

A client called and asked me about Twitter ads. He wanted to know if they were worth the investment.  I told him I hadn't looked into it yet and set out to find out what I could for my own benefit as well.  Along the way, I discovered something nifty and free.  But really really hidden from plain view.  Which is true of a lot of things.  What I found is the topic of this blog article - Twitter Analytics. Here's what you need to do to find these little gems.  Logon

This week I had an interesting conversation with a client. They know we, as a business, are active on social media and are seeing benefits.  My customer has been dabbling in the space for a while but is finding it too hard to keep up with the effort and is considering allowing their employees to also participate in helping with social media.  They asked me what is the right approach to take and after our discussion I realized it would make a good blog article. Social media and the

This image is a screenshot of all of us during a video staff meeting. We're using Google Hangouts and headsets.  All of us have webcams - which pretty much come with newer laptops. Seeing each other in person is SO MUCH MORE effective than just participating on a phone call. The participants are in Chattanooga, Pikeville and Phoenix - but in reality we are all together in the same moment - and that's priceless.  We may never go back to just phone call meetings.   [caption id="

[caption id="attachment_1525" align="alignleft" width="300"] When planning a company strategy be prepared for nothing or extremes.[/caption] If you read my blog, you know we work with and support act!, a CRM tool that is going on 26 years old. It's a great product and one I believe in strongly. I can't imagine a company, particularly a small one, trying to survive without a tool like act! Recently, act! was purchased by Swiftpage. Note that I am showing act with a lower case letter - that's by

[caption id="attachment_1516" align="alignleft" width="300"] The skiils of an architect and consultant make a perfect marriage of styles and ideas for helping a business grow.[/caption] My youngest son is an architect. We, including my oldest son, are computer and business consultants. Sitting in the living room one night we started talking about what he does and how it compliments what we do. We ask a lot of questions when working with clients. The questions are to help us understand the

For the past two years I have been increasing my involvement in social business.  In the process I also kicked up the amount of blog articles I write.  When we switched our website to a Wordpress engine, it made sense to keep blogging current.  And it has worked in increasing the amount of traffic to our site and created additional business. That's all well and good but now comes the hard part.  In the beginning I had all kinds of information to write about.  News is

On a lot of Servers hosting ACT, the database lives on a different drive than C.  This is because C drives are typically kept smaller.  However, SQL likes to store things on the C Drive even if you load the database on a different drive.  Included in this are the index files that are generated to provide a method to perform the Universal Search that started in Version 2012 of ACT.  It is possible to move these files to a larger drive.  Here's how.  Follow the