Tuesday, March 24, 2020

How to generate a list of unique entries from an Excel column


Do you have an excel column filled with bunch of stuff and you want to have a unique list of items in there. You are in the right place :-)

  1. Select the column letter, copy and paste to another location (new sheet or just somewhere else)
  2. Go to Data | Filter | Advanced Filter. Default, Excel will suggest filtering the list "in-place." We prefer copying the unique records to another location, so we can compare the two lists.
  3. Choose "Copy To Another Location", check the box for "Unique Records Only"  and write B1 in the Copy To editor box.
    How to generate a list of unique entries from an Excel column
  4. Press OK, and Hallelujah ... there you go


Friday, May 24, 2019

Wednesday, May 01, 2019

How to print protected / secured files in 3 easy steps

How to print protected / secured files in 3 easy steps ...

  1. Upload to your Google Docs
  2. Double click on it to open & click on Print button on top right corner & save as PDF to your desktop
  3. Double click on the saved file and print (check File-Properties-Security and see if printing is Allowed now).

Monday, April 22, 2019

Saturday, April 13, 2019

MsiExec code 1619: corrupt media

MsiExec code 1619: is probably due to lack of access / corrupt media? check the access list & media itself ...

ERROR_INSTALL_PACKAGE_OPEN_FAILED1619This installation package could not be opened. Verify that the package exists and is accessible, or contact the application vendor to verify that this is a valid Windows Installer package.

Thursday, February 28, 2019

dlvr.it automated posts from website to company pages on LinkedIn

Today I came across this nice tool, to automate the posts from your website / RSS to your social media pages (personal or company pages).

Definitely worth taking a look

Tuesday, February 19, 2019

How to add SSL to wordpress website?

  • Purchasing and installing SSL certificate.  

Ordering SSL in your website Cpanel
  • This allows you to use https:// URL, but if you wish your custom website to use https:// URL so you can see that secure mark then you need to do a little more.
  • For Wordpress websites, you should now configure your WordPress to operate with https:// To complete this you need to update the two site URLs in Settings > General menu of your WordPress admin panel to be with https://.
  • Finally you may need a plugin for the website to operate with SSL like "Really Simple SSL"

Restricted access to a test website for Testing purpose with .htaccess ...

If you also need to create a restricted access to a subdomain on your website due to testing, you can follow these steps.

  • You can create a temporary subdomain. E.g. testSubDomain.MyWesbsite.com
  • You can make the website accessible only for your IP address by creating a file called .htaccess in the directory of the website ( if there isn't such a file already) and adding the following code inside:

    order deny,allow
    deny from all
    allow from  

    Simply replace with the IP address from which you will be accessing the website.

Monday, February 18, 2019

Promoting Your Public Profile

If you want to add your LinkedIn profile (personal profile) to your HTML based website, there is an easy way by LinkedIn.

On the Public Profile page, click Create a public profile badge from the bottom of the right rail to get started. It will give you some options & sizes to choose from & you can copy paste that in your HTML code.

Show all posts on a specific tag on a page in menu

If you want to put one specific tag on a page & add it on the menu, it's pretty simple. In WordPress you can display posts with same tag on tag archive page. 
Login into WordPress admin panel, navigate to Appearance -> Menus. Find your primary menu that is in use, and select it. Now, click on Screen Options button in the upper right corner (all the way up to the right), & check option Tags so they are also shown on your menu List (left side of the page). 
This way you will get additional menu panel Tags. Browse to the desired tag & add it to your menu. You are good to go :-)

Sunday, February 17, 2019

MySql & Ubuntu , installation & uninstall (removing)

Installing MySql on Ubuntu

sudo apt-get install mysql-client mysql-server
Uninstall & Removing MySql on Ubuntu

sudo apt-get remove -y mysql-*
sudo apt-get purge -y mysql-*

Saturday, January 14, 2017

strikethrough shortcut in Excel

Fastest way to produce strikethrough in Excel is to select the text (or the cell) you want to strikethrough, and then simply press Control+5. You can also use that shortcut to remove strikethrough. PERFECT. Meaning you dont have to through the hassle of formatting your cell and then press the underline check box in the Font window that pops up.

Thursday, May 12, 2016

Missing Remote Desktop Connection under Accessories ?

Missing your remote desktop connection under Accessories in Windows?

1. Go to "C:\Windows\System32" folder and find the "mstsc.exe".
b. Create a shortcut out of it.
c. Move it to "C:\Documents and Settings\All Users\Start
Menu\Programs\Accessories\Communications" folder.
d. The system may ask to make this short cut on the desktop. Click yes, then simply
cut the shortcut from the desktop and paste in the Communications folder.
e. Rename the shortcut "Remote Desktop Connection".

Monday, May 02, 2016

copy a text to clipboard in Java

Easily done via Java Toolkit

StringSelection selection = new StringSelection(theString);
Clipboard clipboard = Toolkit.getDefaultToolkit().getSystemClipboard();
clipboard.setContents(selection, selection);

commenting a line in Netbeans

commenting a line in Netbeans ? Try this

Ctrl + Shift + C

Source : https://netbeans.org/project_downloads/usersguide/shortcuts-80.pdf

Sunday, April 10, 2016

Wireshark filter

Some Wireshark filter tricks
1.       ip.addr == [Sets a filter for any packet with, as either the source or dest]
2.       ip.addr==  && ip.addr== [sets a conversation filter between the two defined IP addresses]
3.       http or dns [sets a filter to display all http and dns]
4.       tcp.port==4000 [sets a filter for any TCP packet with 4000 as a source or dest port]
5.       tcp.flags.reset==1 [displays all TCP resets]
6.       http.request [displays all HTTP GET requests]
7.       tcp contains traffic [displays all TCP packets that contain the word ‘traffic’. Excellent when searching on a specific string or user ID]
8.       !(arp or icmp or dns) [masks out arp, icmp, dns, or whatever other protocols may be background noise. Allowing you to focus on the traffic of interest]
9.       udp contains 33:27:58 [sets a filter for the HEX values of 0x33 0x27 0x58 at any offset]
10.   tcp.analysis.retransmission [displays all retransmissions in the trace. Helps when tracking down slow application performance and packet loss]

Tuesday, March 22, 2016

Shortcut to insert new row in Excel

If you press Alt + I + R, you would simply get a new row inserted right away in your Excel sheet :-)

Tuesday, October 07, 2014

keeping tasks tab in view in Outlook 2013, HOWTO

Tiered of clicking on Tasks to see remaining tasks and of-course forgetting them becuase they are not right in front of your eyes all the time, well then read this post from Microsoft which helps you to keep the tasks always visible in your Outlook 2013

Monday, October 06, 2014

Remove Windows Live Messenger !!! HOWTO

If you are as pissed as me about having Live messenger launching everytime you start your windows, then follow the following lines to get rid of it :-P

On the Desktop click the Start button
In the Search field type Programs and Features and hit enter
Locate Windows Live Essentials and double click
Select Uninstall and hit Continue
Place a checkmark by Messenger and click continue

Sunday, September 28, 2014

Android on Ubuntu & tricks with Thinkpad laptop

Want to install android on a virtual machine on your Ubuntu? Well it's not that hard, have a look at this tutorial which simply tells you how to do it :-)


Important Update : Talking about it being easy, if you are having a Lenovo or Asus laptop remember to download the special iso file made for laptops with special hardware. android-x86-4.0-r1-thinkpad.iso in my case. Also after you are finished installing and you do not have the mouse in the Virtual box windows when u start the Android, read this article at PC world which helps you with that :-P


It basically only is saying the following which is useful for you : "Click Machine in VirtualBox’s toolbar, and select Disable Mouse Integration. Dialog boxes may appear; if so, click through them and continue. Disabling mouse integration allows you to manually control whether your mouse is controlling your primary OS or Android-x86. Pressing the right Ctrl button on your keyboard switches between the two operating systems. To swipe, click and hold the mouse button, and then move the mouse.
With that taken care of, you’re free to explore Android on your PC!"