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.
Do Not Call Registry – How To Add Your Mobile number To this & Stop Marketing Calls & SMS?
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.
How to Split Date & Time – In Excel Worksheet?
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 […]
Excel Add WorkDays To Date – Excluding Weekends & Holidays
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.
Number of Working Days in a Year – Between Two Dates – Excel
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.
Excel VBA – Find UpperCase Word in String or Worksheet
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 […]
Excel Insert Button Greyed Out – Disabled – How To Enable It?
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
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 …
Excel VBA Convert SpellNumber – Amount (Numbers) To Words – Both US & India Formats
Get Amount converted from Number to Words both in Millions & Crores format. This Excel VBA code supports different currency formats like US Dollars & Indian Rupee formats as well. Be it Millions, Billions or Lakhs Crores, this code does it all.
Excel VBA – Loop Through All Open Workbooks – Get Names
Excel VBA code to Loop through all Open Workbooks. Also, use the same code to get names of all the open workbooks. This is useful to scan though & get the properties of any number of open workbook in the current system.