Several people have recently asked me how they can de-dupe an email marketing list in Excel. The common problem is when you add the unsubscribes to the marketing list spreadsheet, you can sort them and see that there are duplicates, and then you can click the button to remove duplicates, however, it then takes out all of the unsubscribes that you just added.
Here is a simple formula that you can use to solve this issue: =if(countif(a:a,a2)>1,””,a2)
(This formula assumes that you are using column A and you have a header in A1. You can place this formula on B2 and drag it down through the bottom of your list in column A.)
What this is doing is counting how many times a particular email is listed anywhere in column A. If an email is showing up more than 1 time then it will return a value of nothing in the cell in column B. If the email only shows up 1 time in column A, then the value that shows up in column B will be the email address next to it in column A.
After you have completed this formula, you’ll want to copy the entire list in column B and then paste the values. This will remove the formula from the cells and give you a list that you can work with. You can also click the remove duplicates button to get rid of the blank cells.
Here is a quick video that I created to show exactly how to do this: http://screencast.com/t/7exEtCr50x
Let me know if this is helpful for you!
We started this week with tax day. Of course I spent most of my evening engaging with several other people that waited until the last minute to mail in their taxes at the post office. And many of them were not so happy about it. I’ve become what I like to think of as a “Happy Tax Payer”. I’m happy to contribute to making our roads better, our streets safe, our children more educated and everything else that our tax dollars go to pay for.
Jim Rohn says, “You’ve got to feed the goose that lays the golden eggs. Of course, we don’t want the goose to get too fat! Just feed her the right amount so she can keep producing the golden eggs.”
I’m also very happy to say that I paid more tax for 2012 than I’ve ever paid in my life, and I’m proud of it. I also have a new goal to pay more in taxes every year. I’ve mentioned this to a few people and gotten a very strange reaction. My thought process is this… If you’ve read the book Think and Grow Rich or ever heard Earl Nightingale talk about “the strangest secret”, then you’ve probably heard the quote, “You get what you think about most of the time.”
People that think about paying less in taxes will likely find a way to do just that… pay less. How do you pay less in taxes? Easy, you make less money. I like to think the opposite and think about how I can pay more taxes. If I’m paying more tax, then I’m obviously making more money.
Don’t get me wrong, I want to pay the least amount that I legally am allowed to pay, but I want that legal amount to be more and more each year.
Anyone else want to join me on my journey of paying more in taxes? 🙂
Over the last month or so, I’ve had many conversations with partners and other connections in my life about being a life long learner. As many of you know, I do not have a college degree, but I do have an education background through my experience at QuickStart Intelligence. One of the things that has helped me become the person/professional that I am today is the University of Lincoln. If you’ve never heard of it, it may be because it’s actually my car. It’s highly unlikely that you’ll get into my car and hear the radio playing music. You’ll nearly always hear speakers like Jim Rohn, Brian Tracy, Denis Waitley or someone else that can help me achieve my goals.
If you’re like me, you’re always looking for that next opportunity to learn something that can help you move forward. If you think about how much time you spend in the car, you may have found your answer. I was recently getting my hair cut and talking to the stylist about this very topic. She mentioned that she commutes about 15 minutes each way to work 6 days per week. That’s 3 hours per week. If you multiply that by 50 weeks (we’ll give her 2 weeks vacation!) then she spends 150 hours per year in her car. Think about how much education that is, and that’s not even counting the trips to the grocery store, dinners or vacation trips.
There are a couple of people in my life that have recently taken the plunge into creating their own University on Wheels! My buddy Joel started with the “Art of Exceptional Living” by Jim Rohn, and my co-worker Morris started his journey with Brian Tracy’s Goals Setting Workshop. It brought great joy to me when these guys not only started utilizing their cars for a learning environment, but they also have decided to continue learning and adding to their libraries.
I’m sure there are more of you that use your car to continue your education. I’m always looking for new curriculum for my University of Lincoln. What are some of your favorite programs that you listen to? What would you recommend?
I recently had lunch with a great friend of mine. I always consider it an honor with someone I care about calls me and asks me to lunch because they respect my opinion. We had some great conversations through the lunch, but one of the great reminders that I received was a good goal setting reminder. It is one of my beliefs that you can’t get somewhere when you don’t know where you are going. I even like to use the example of when you get in your car, how will you get to where you’re going if you don’t have an end goal in mind?
The first step in goal setting is to think of what you want and write it down. It sounds easy, but you would be surprised on how many people have not taken this step. Use this as an exercise to think of as many things that you want, and write them all down.
Let’s do this… I’m going to write a few topics to consider, and I’d like for you to take a few minutes to think about what you want to accomplish in your life.
Do you want to own a home or homes?
Do you want a new car?
Do you want to make a certain amount of money?
Do you want to be worth a certain amount of money?
Do you want to have a family?
Are there certain things that you would like to accomplish with your family?
Is there someplace that you would like to go?
Is there someone that you would like to meet?
Is there a vacation that you’ve always wanted to take?
Have you always wanted a certain type of wardrobe?
Is there a certain job that you’ve always wanted?
Do you want to work with a certain company?
Do you want to own your own business?
Do you want to join a certain social community?
Do you want to make more friends?
Do you want to do more with charity?
Would you like to be more involved in your church or community?
If nothing else, take just one minute and write down one goal today. You’ll be surprised how much it will impact the things that you do.
I know a lot of people that write down daily lists of things to accomplish. This in itself is a list of goals. Think about how much more productive you are when you make a list of things to do as opposed to when you attack a day with no goal in mind. Jim Rohn says, “Don’t start the day before the day is finished. Don’t start the week before the week is finished.” He also says it’s a good idea to plan out your month and year, but of course these are much more difficult. At least have an outline so you can plan out time for your personal and professional life.
This is such a simple thing to do, and yet, many people don’t do it. Why? Because it’s easier NOT to do it! Take a minute and set a few goals for yourself!
Many times I hear people talk about their struggles in getting value out of events and social communities because they are not allowed to talk about their product or services. In today’s day and age, people don’t want to be pitched to. When I first started in sales it took a lot of time to build your craft of learning how to sell people a product. Very quickly this changed dramatically. Today, people want to “buy” more than they want to be “sold.”
So how do you do this? You sell through stories. If you learn to tell the stories of your key successes and testimonials, then you’ll win more business than ever before. Let me give you a few examples of how this works:
I love to tell the story about how I was able to get my girlfriend to switch to a Windows Phone HTC 8X from her iPhone. I tell people about how she was concerned that all of her favorite apps would not be available, but when she started looking through the store, she saw that all of the apps that she used were in there. When she started learning how the customization of the tiles worked for the home screen, she fell in love. Every day she started changing the tiles around to make it perfect. She really likes to change the color of tiles depending on her mood each day. She was also concerned that she was going to lose her music from her iTumes, but we were easily able to import all of her music and photos to her 8x phone. Now she listen to her music and customize her phone to fit her lifestyle.
I tell this story for two reasons: First, I love that she switched from the iPhone, but this story allows me to sell the Windows Phone platform without actually trying to sell anyone. Nearly everyone I mention this story to asks me to tell them more details about the phone or they ask me to show them my phone.
We all have stories and testimonials from our customers. These are the best selling tools that you have in your toolbox. Make sure that you use them! It’s free, and I guarantee you will get more return from using this technique than just about anything else that you do to try to sell.
I would love to hear some of your stories and testimonials. Please leave a comment below of a story that you use in your business.
The best decision you will ever make is to actually make a decision! I once heard a saying that went like this, “An unsuccessful man always has to make the right decision, where a successful man makes all of the decisions he makes, the right ones.” There is a huge difference in the two, and I can tell you from personal experience that delaying a decision is as close to a “living hell” as I think we can possibly get.
I would be willing to bet that we have all been in a place where we had a big decision to make, and when you really started thinking about it, all of your options were good. You just couldn’t make up your mind which one to go with. In a scenario like this, my suggestion is to pick one and make it right. If both of the decisions are good, then you can’t make a bad choice. I take that back… you can make a bad choice if you procrastinate on making a choice or you don’t make a choice at all. I had an old friend named Warren that used to tell me that the biggest nation in world is procrastination. I’ll never forget that, and I think about it every time I have a tough decision to make. It always helps me remember that the only bad decision is no decision.
Two years ago at the Microsoft Worldwide Partner Conference, the keynote speaker was Richard Branson. I’ve always admired Mr. Branson for his success in business. I don’t know much about him other than his business success, though. He really grabbed my attention in his post keynote questioning. The moderator asked the question, “What makes you so successful?” To which Branson responded, “We have a saying in my companies called, “Screw it, let’s do it!”” He said that many times people talk about all of the things that could go wrong and they never try to accomplish their goals. They spend so much time on the negatives that they talk themselves out of even trying. He made a great point to stress that we can accomplish much more than we think, and if you just make the decision and give it your all, you will succeed more often.
There was another time that I was listening to Brian Tracy on a CD talk about failure. He said that many times an entrepreneur will try to create a successful business 20+ times, and most people will say that this person failed if their business doesn’t thrive. He contests that this person succeeded in finding 20 ways not to start a business, and that this person would eventually find a new way to make his/her business successful.
We learn from everything that we do. I would like to challenge you to try some new things and make some tough decisions. Then execute on your decision. Don’t look back! Don’t think that you made the wrong decision. Do everything in your power to make the decision you made the right one.
The Microsoft Retail Store at South Coast Plaza in Costa Mesa, CA will be hosting PRE-LAUNCH demos of the Surface Pro next week from Monday through Friday at 10am, 2pm and 6pm. All Microsoft Partners and your customers are welcome to attend these demos. You will not be able to purchase a device until Saturday, but you can get an early sneak peak at this game changing device.
If you have some VIP clients that you would like to reserve a special time to have a one on one demo, leave a comment below and I’ll reach out to you to set up a special demo at a special time for you and your customer.
Bing it on!