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

Hi,

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

Result

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 :-)

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
http://office.microsoft.com/en-001/outlook-help/keep-upcoming-tasks-always-in-view-HA102809465.aspx

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

Once it is uninstalled, select close and exit out of Programs and features

Source : http://answers.microsoft.com/en-us/windowslive/forum/messenger-wlsettings/how-to-uninstall-windows-live-messenger/626144e2-fd59-4b98-81ac-1db56f057ef3

Disable Taskbar Thumbnail Preview in Windows 7; HOWTO

1. Start button -> type on search bar gpedit.msc & Enter
2. Go to User Configuration, Administrative Templates, and Start Menu and Taskbar
3. Fina “Turn off Taskbar Thumbnails” and open it.
4. Select Disable from the opened window
5. Done :-)

Change product key in Office 2010; HOWTO

1. Control Panel
2. Uninstall a Program / Programs & features
3. Office 2010
4. Click on Change button
5. Choose Enter new product key & Press Continute
6. Type your new product key and also make sure to check the option Attempt to automatically activate my product online to automatically activate your Office 2010 suite. Now click on Continue and then on Install Now.

HOWTO : add/remove a String Item to jComboBox, Java

jComboBox :

// Add an item to the start of the list
cb.insertItemAt("item0", 0);

// Add an item after the first item
cb.insertItemAt("item0.5", 1);

// Add an item to the end of the list
cb.addItem("item3");

// Remove first item
cb.removeItemAt(0);

// Remove the last item
cb.removeItemAt(cb.getItemCount()-1);

// Remove all items
cb.removeAllItems();

HOWTO : get a list of available ports, Java

If you want to ahve a list over all ports, the code down here can help alot

protected void list() {
// get list of ports available on this particular computer,
// by calling static method in CommPortIdentifier.
Enumeration portList = CommPortIdentifier.getPortIdentifiers();

// Process the list.
while (portList.hasMoreElements()) {
CommPortIdentifier cpi = (CommPortIdentifier) portList.nextElement();
System.out.print("Port " + cpi.getName() + " ");
if (cpi.getPortType() == CommPortIdentifier.PORT_SERIAL) {
System.out.println("is a Serial Port: " + cpi);
} else if (cpi.getPortType() == CommPortIdentifier.PORT_PARALLEL) {
System.out.println("is a Parallel Port: " + cpi);
} else {
System.out.println("is an Unknown Port: " + cpi);
}
}
}

Source : java2s.com, modified as javax.comm does not exist anymore on Windows and RxTx should be used

HOWTO : change the location of Desktop folder at Windwos 7

If like me you would also like to change the location of your Desktop folder(security reasons or willing to share the same Desktop on all of your computers), keep reading.


The solution is pretty simple :-) Simply go to following path : 
C:/users/name/Desktop
Then right click on the Desktop folder and then choose properties. After it click on "Location tab" and there you can change the location of the Desktop folder.


in XP, it is the same story but a little bit more complicated as you should go to registery(Start->Run->regedit) and change the value of this entry in registry : 


HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders\Desktop

HOWTO : insert a code in blogspot weblogs

<"border: 1px dashed rgb(153, 153, 153); padding: 5px; overflow: auto; font-family: Andale Mono,Lucida Console,Monaco,fixed,monospace; color: rgb(0, 0, 0); background-color: rgb(238, 238, 238); font-size: 12px; line-height: 14px; width: 100%>


Some code here

HOWTO : Add a program to Applications Menu

In Gnome(edgy) : System -> Preferences there is an item called "Main Menu". Here you to edit the application menu.

HOWTO : Find out if you have a 64 bit Ubuntu or a 32 bit one ?

Simply open a terminal and write the following command :

uname -m

x86_64 = 64 bit
i686 = 32 bit

Configuration about PHP server, HOWTO

If you are wondering about the configuration of the PHP server you have, you can simply make a PHP file with following command :


<?php





phpinfo();





?>


and simply place the file in the localhost folder and browse it in an Internet Browser. You would simply have all the information you need. The result will be something like the picture down here(Take from Wiki)