How to Remove Duplicate Rows in Excel

Apply below given the formula to remove duplicate rows in Excel:

=IF(MAX(COUNTIF(A1:A3306,A1:A3306))>1,"Duplicates","No Duplicates")

A1 is the Column, change to any column based upon your Excel Spread Sheet.

A3306 is the range of rows, change it your range of rows, it could be 100 or 200 or more depends upon the number of rows.

Rest, keep it default, and apply the formula next to the all rows and the duplicate rows will appear.

Cheers!!!

How to Change the Blogspot (Blogger) Post Title

How to Change the Blogspot (Blogger) Post Title

Generally by default Blogspot (Blogger) Post titles will be prefixed with Blogs Name first then Post Title. If you want to do post title Search Engines Friendly, follow the steps given below:
First Click on Design on the Top Right Corner or try to find Design link based upon your Blog Template, then click on Edit Html link to launch your Blog's html Code.
Look for the below given code in the Html Code.

<title><data:blog.pageTitle/></title>

Now, Replace the above Code with the below given code, and save Template. That's it now you will see that all your Posts Titles changed with your Desired Post Title.

<b:if cond='data:blog.pageType == "index"'><title><data:blog.title/></title><b:else/><title><data:blog.pageName/></title></b:if>

Enjoy!!