Quickly display unique items in an excel list using advanced filters
Imagine you have long list of data and you need to quickly identify which of the items are unique. You can use Advanced Filters to do this. Just select the list of items you want to filter, go to menu > Data > Filter > Advanced filter. You will see a dialog box like this: […]
Formatting numbers in excel – few tips
Reader Nikhil Shah asks in an email: Dear Chandoo, I have some Error In Excel sheet. Problem :- I have a locker number 01234 567890, in Excel it will be displayed as 01234 567890 with the space. However if it was entered as 01234567890, Excel will display it as 1234567890, without the leading zero. If […]
Incredible hulk strikes IMDB – awesome online ad
This is awesome, the new incredible hulk campaign on IMDB is nicely done, I have taken a few screen shots of it to post here, just in case they removed it (but go see it on IMDB to understand what I mean) This shows how to create incredible advertisements by integrating flash (rich media) with […]
App. idea for iPhone developers (for other location aware phones as well)
Now that iPhone is going to have GPS built in, here is an application idea any of you iPhone app developers out there. The idea is simple, whenever the phone-holder is driving, this app would automatically answer calls with a pre-recorded message (that can go like, “Hi.., I am driving right now, please leave a […]
Cool outdoor advertising by Google Russia
This is cool, apparently Google resorted to this to beat the leading Russian search provider Yandex. I am not sure whether this would be effective though. Its like forcing people to break a habit. This, probably is the most challenging task for marketers all over the world. When customers are used to Yandex or Naver […]
“I am feeling lucky” Firefox Search plug-in
While trying to understand how the Mozilla firefox search plug-ins work [ more ] I got curious and wrote a search plug-in that will take you to the first Google search result directly instead of displaying the results pages, ie mimicking the “I am feeling lucky” searches. Feel free to download and install it. 1. […]
Improve productivity by opening same excel sheet in 2 windows – quick tip
Often we work with large data sheets and it becomes tedious if you want to compare data / formulas etc. You can try split (menu > window > split or alt+w+s) to break the sheet in to two. But there is another cool thing you can do, open a new window for the spreadsheet. Just […]