Remove duplicate entity from a column

Select the column by clicking top of the column, then go to data-validation, select custom and type the

custom rule =COUNTIF(A:A,A1)=1

Access Denied error in Windows 8

after long time posting again..

I moved to windows 8,have some files from windows xp,now can not access them,access denied error

Here is how to take ownership of those files in windows 8(gui method did not work surprisingly)

a) Press “Windows Key + Q” to open Charms Bar.
b) Type “cmd” without quotes in the search box.
c) On the left pane, right click on the “cmd” option and select “Run as Administrator”.
d) Type "TAKEOWN /F c:\windows\winsxs /A /R" without quotes press enter. 
Note: Here c:\windows\winsxs is the file location. 
e) Type “ICACLS c:\windows\winsxs /grant:r Everyone:F /T” without quotes and press enter. 
Note: Here c:\windows\winsxs is the file location

Now even after doing that and even after getting the success of the commands I was still getting  the access denied,so I tried to to take ownership of the whole folder and enabled inheritance and it worked unlike before.

Here is the the link that helped me.

http://answers.microsoft.com/en-us/windows/forum/windows_8-security/you-do-not-have-permission-to-view-this-objects/5939dbf4-ca81-4f14-b455-ede115af924e 

Conditional formatting based on numerical values using different color

Right click on a column containing 10 ,20 and 30 and format cells,click custom and type

[BLUE][=>30]00;[MAGENTA][=>20]00;[green]00

and you are done.

you can not change the color of any cell using traditional method

Java not working in Internet Explorer after installing java on Windows 8 solved

I have faced this error,fortunately found the solve.

Reinstall Java using offline version.(just the jre in the second time works for me)

    Go to the Windows offline page

    On the download page, click Agree and Start Free Java Download

    If you've already installed the version, you will see a message, This software has already been installed on your computer. Would you like to reinstall it?

    Click Yes and reinstall,and you are done.

source:https://java.com/en/download/help/ie_tips.xml

What is PAE Kernel

(PAE) stand for Physical Address Extension. It's a feature of x86 and x86-64 processors that allows more than 4 Gigabytes of physical memory to be used in 32-bit systems.

To enable PAE, open terminal and type the following command:

sudo apt-get install linux-headers-server linux-image-server linux-server

reboot.