Posts

How to find duplicates data in Excel

-
Image
To find duplicates in Excel. Go here to remove duplicates. 1. Select the range A1:C10.       2. On the Home tab, click Conditional Formatting, Highlight Cells Rules, Duplicate Values...       3. Select a formatting style and click OK.      Result. Excel highlights the duplicate names.     Note: select Unique from the first drop-down list to highlight the unique names. As you can see, Excel highlights duplicates (Juliet, Delta), triplicates (Sierra), quadruplicates (if we have any), etc. Execute the following steps to highlight triplicates only. 4. First, clear the previous conditional formatting rule. 5. Select the range A1:C10. 6. On the Home tab, click Conditional Formatting, New Rule...      7. Select "Use a formula to determine which cells to format". 8. Enter the formula =COUNTIF($A$1:$C$10,A1)=3 9. Select a formatting style and click OK.      ...
Post a Comment
Read more

Tips & Tricks for Directory Submission SEO

-
Image
Do & Don't Tips to help improve your website submission to web directories Tips and Tricks to help improve your website submission to web directories in your SEO link building technique. If anything I missed or any wrong statement, kindly give the suggestion in the below comment session. Thank you :)
Post a Comment
Read more

Looking to Keyword ranking check

-
Image
Keyword Rank Checker How you check the ranking for your targeting keywords. Its manual or any tool? Is 10-20 keywords manual ranking is okay, if you want to check 100 keywords!!! Looking for any best keyword rank checker tool. Due to some ranking fluctuation most of the rank checker, its website or tool does not give you the appropriate ranking position. I share you couple of best online ranking tool for Keyword rank checker. Here you to know the exact position of a keyword based on country / Region. Allorank SOURCE:  http://www.allorank.com/check-position Whatsmyserp SOURCE:  http://www.whatsmyserp.com/serpcheck.php
Post a Comment
Read more