MS Excel - Find Duplicates in a Coloumn

Lets say you have a column full of data in your excel and you want to find out the duplicates in it:

Method 1 - Using Countif function

Let's say your data is this

Column A
Siri
Sekhar
Sahan
Sahiti
Sahana
Siri
Sekhar
Sekhar

Now in Column B enter the formula in the first cell
=CountIF($A$1:$A$8, A1)

Then sort the data by Column B and you will know which data is repeated

Method 2 - Using Pivot Table

In Excel 2013, go to Insert --> Pivot Table
When asked to select Table or Range, select the Column A data

Now when the pivot table fields are shown select the Column A and drag it to "Row Labels" and "Values" - Set "Values" to Count

This will give you the count of each of the element thus enabling you to find the duplicates.

Comments

wget error–“zsh: parse error near &”

There is no doubt that I prefer wget way over any other type of downloads… Syntax: wget <DOWNLOAD_URL> If you get this error “ zsh: parse error near & ” then its probably because your download URL has a “&” so you should try giving your DOWNLOAD_URL in double quotes wget “<DOWNLOAD_URL>” If you are trying to download from a site which needs you to give your credentials then you can try giving it this way wget --http-user=<UserName> --http-password=<Password> “<DOWNLOAD_URL>” Hope this helps

How to Unpack a tar file on Windows?

On Windows: You can download a simple command line tool to do this. You can download the tool from here Usage can be found on the website but pasting it here too for convenience: C:\>TarTool.exe Usage : C:\>TarTool.exe sourceFile destinationDirectory C:\>TarTool.exe D:\sample.tar.gz ./ C:\>TarTool.exe sample.tgz temp C:\>TarTool.exe -x sample.tar temp TarTool 2.0 Beta supports bzip2 decompression for files with extensions like tar.bz2 and .bz2 . TarTool -xj sample.tar.bz2 temp or TarTool -j sample.bz2 Download TarTool 2.0 Beta from here Unpack a .txz file on Windows Use the 7zip tool to unpack a .txz file on windows On Linux: You can use the bzip2 and tar combined to do this… for ex: bzip2 –cd <tar.bz_fileName> | tar –xvf - This will unpack the contents of the tar.bz file Happy Un-Tar-ing

How to check if my xpath is valid using firebug?

Yes, you can verify if your xpath is pointing to the right source on the web application under test using FireBug. Here is how: Go to the Web Application under test We'll take Google for simplicity reasons Open FireBug - Go to the Console Console can also be seen at the bottom of the page, so don't worry they both are the same. They can be switched as follows: Type in $x("Your xpath here") on the command line prompt as shown below: Hit Enter/Run You will get to see the element which was filtered out with your XPath expression

Tech Talk

Search This Blog