Excel compare two columns & highlight the duplicates or unique values. This is a simple built in option available in conditional formatting to change the background of duplicate or unique values in the selected range of values.
Send SMS as Start 0 to this number & add your mobile number to the National Do not Call Registry of India Telecom department. This will stop unwanted marketing/promotional calls & sms to your mobile number.
Worksheet Date & Time – How to Split it? In worksheet type this function to get Time enter the formula ‘=Now()’ . It will return the default value as today’s date & time in the cell. Something like this. ‘5/7/2018 13:53’ You can see that there is a Date part… [Continue Reading]
How To Find Number of days between Two Dates? Sometimes we need to know the exact time gap or days in between two consecutive years or months. Here you will find how to find this difference in: Worksheet Excel VBA Macro code 1. Worksheet Find Days between 2 Dates Simplest… [Continue Reading]
Excel – Add Days to Date – Excluding weekends & holidays. This formula & VBA function will add workdays to a start date & give the end date to plan for your project or task.
Use this Excel formula to find the number of working days between two dates or in a year. This formula also has option to provide custom holiday list to be included in the working days calculation.
Finding Uppercase Words in String? Use this direct method to find out whether any lengthy string has words with all Caps. For example: This line has one WORD as all caps. If a word has all letters in caps, then it might denote some important keyword. In that case, to… [Continue Reading]
How to Convert PDF to Word document using the simple methods explained in this method. Also, there are certain online tool available through which PDF file can be uploaded and converted to a MS Word document.
Option to enable Insert button or option in Excel. Sometimes this option gets greyed out or disappears. User wont be able to insert row or column. Try this option to Enable it back
Excel VBA Find String in Range Return Row Change Background color Remove Duplicates. Get code to perform search operation for a string in worksheet cell range. Also use the same to find duplicates, change cell color based on value, find row of search string …
- Block Apps in FaceBook print screen Excel Countif Record Macro Timer in Excel Task Manager VCF HTML Table Import Data Thumbnails Text to Speech TTS Candy Crush C++ Programing Machine learning AI bulk email Excel VBA vba color index vba color codes Android social media Twitter Google+ Google Adsense Tips bitcoin Calendar in Excel outlook vba mass email Data Mining Excel Macro Facebook WhatsApp python Wordpress