Category: Standard functions

Convert US addresses from cells (one column with 1 line for Name, 1 line for address, one line for City, State and Zip code) into...

This Excel file will convert a table of two columns into a Column-Row table Using functions only and auto-updated once the Main table update In...

It is to demonstrate how to do multiple validations in the same sheet, or as we want to call it Mutliple-dual-validations that depend on each...

Here is the free file for a special request by a client He wanted to have multiple cells having Data – Validation to same list...

Once you open the sheet and enable macros, you can use function: =WorksheetsNo() To get total number of sheets in that workbook And use function:...

Using Index and CountA Formulas, Names and Forms > ListBox to have a list with connected formulas Can also be used as form to read...

Creating a Data Validation based on another Data Validation Meaning that when you select from a drop down from the first the second will be...