Create Drop down list in Google Spreadsheet using this simple tip. Restrict user from entering only the values from the drop down list.
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]
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]
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 …
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.