Saturday, May 23, 2009
Friday, May 22, 2009
Column B contains a value relating to each data string
Column E contains if statement to compare one row against another like this:
What I need to do is in column E have a formula that returns another
STOP *if* column E contains STOP and column B is not equal to D
My brain is so dead - this should be simple and I'm just not getting it.
I realize there is deduping in Excel 2007 but the client wants the
data in this specific format.
Thanks to @mrrichardson for helping me out!
Wednesday, May 20, 2009
Over the past 20 years, I have had the chance to have a glimpse at the inner workings of literally tens of thousands of businesses – ranging from one-person shows to many of the world’s largest companies. I’ve also built several successful businesses of my own – both online and offline. I don’t have all of the answers to what makes one business succeed while another fails. However, I do believe that the insight I have goes beyond what you could find in any single book, course or even a full business school program.
In June, I’ll be rolling out a coaching program geared to small business owners and start-ups. This will be the first time I’ve done something like this. I’m not doing it for the money. I can make money more easily doing other things. The last thing I want at this stage of my life is to have more work. I am just feeling frustrated with the preponderance of misinformation when it comes to doing business online. I know there are a lot of good, decent people out there that genuinely want to create a business of substance. I feel confident I can provide the keys to unlock the magic kingdom for these people. The focus will be on becoming a true entrepreneur as opposed to being merely a self-employed technician or professional.
Before the program is launched, I’ll be sharing some general thoughts via my blog and eventually through the program’s website. This will give people who may be interested in the program a better idea of what they can expect if they choose to participate. Unlike the actual program, the content won't be provided in any particular order; i.e. you can expect me to jump around a lot. :)