Shuffle a list of numbers / items in excel spreadsheet
Here is a quick Monday tip for data junkies. If you want to shuffle a list of numbers or cells in excel in random order you can do that with “data > sort” menu option of excel. First insert a column next to the list you want to shuffle and enter random numbers in each […]
Dear Microsoft, Blog is a real word
Dear Microsoft (and other guys who design software that can be used to write something): Blog is a real word, just like bog or bloc or blot or blow or blob. So please add it to your esteemed dictionaries and stop harassing everyone with the wiggly red lines. Of course you can blame me for […]
Photographic Fridays #6 – Where do you want to go today?
Yesterday evening I have suddenly realized that I don’t have any photos to post for today edition of Photographic Fridays, I didn’t want this category to be a still born like the erstwhile Calvin fund 😀 So I took out the D40 and marched out of house in search a subject worth my clickitch. While […]
Mute conversations in Gmail to not follow a specific thread of mails
Do you know that you can mute conversations in gmail if you are do not want to see that lengthy thread on single subjected that people wont give up. Just select the mail / conversation you want to mute Click on “More actions” and select “mute” Enjoy the bliss If you want search for muted […]
Cool infographics around the web
Starting this week I will post cool infographics from around the web, 4-5 of them a week to inspire , to give more ideas on presenting information and to provide some eye candy for awesome readers @ Pointy Haired Dilbert. Go ahead, click through these awesome graphics: California Walkability Score Heat Map Lee Byron took […]
Watch out if you are buying insurance online at GEICO – your password is not encrypted
I have noticed something totally strange while trying to get an auto insurance quote online at GEICO. See it for yourself. They are showing your password in the URL… OMG 😮 Make sure you don’t use the site for getting new quotes as it could be a potential privacy breach as anyone watching the URLs […]
Extract URLs from an excel spreadsheet cell using UDFs
Often my work involves processing web page data in excel sheets. This includes extracting the hyperlinks from cell contents. There is no formula for extracting hyperlinks though, you can right click on cell and choose “edit hyperlink” to see which address the cell is linking to. But that is a tedious process especially if you […]