Profile cover photo
Profile photo
MasterExcel
142 followers -
Everyday is a learning day
Everyday is a learning day

142 followers
About
MasterExcel's interests
MasterExcel's posts

Post has attachment
DESCRIPTION From Text to Math: VBA or Excel 4 Macro Function: EVALUATION See Mr Excel and excelisfun use two methods to convert a text string to a match expression that can calculate the correct answer: 1. VBA code 2. SUBSTITUTE, SUBSTITUTE formulas and…

Post has attachment

Post has attachment
Excel Data Validation: List, Date, Time, Custom (22 Examples) DESCRIPTION Topics in this video: 1. Data Validation to allow only whole numbers between an upper and lower limit. 2. Create an Input Message for your Data Validation. 3. Error Message with…

Post has attachment
DESCRIPTION Merge Product and Sub-Product Text; VBA or Wild INDEX Formula See Mr Excel and excelisfun use two methods to take a table of product names, each with 6 sub-products, and unwind the table to merge the products and sub-products into a sigle…

Post has attachment
When you type the first few letter of an entry into a cell Excel can complete the entry automatically using an option known as Autocomplete. It does this by building a list based on the date already entered in the current column. How To Use Autocomplete…

Post has attachment

Post has attachment
How To Track Down Excel Formula Errors (16 Examples) DESCRIPTION Topics in this video: 1. List of possible errors in Excel. 2. 4 Steps to finding formula errors. 3. 3 Examples of how to use the 4 steps. 4. Cleaning Text data with the TRIM function and…

Post has attachment
DESCRIPTION New Running Count Formula After Each Zero Value (Cumulative Count) Learn how to create a New Running Count (Cumulative Count) Formula After Each Zero Value using the IF and SUM functions. Trick from Bill Szysz at YouTube. See that the SUM…

Post has attachment
DESCRIPTION Add Nth Largest Values With Three Criteria Dynamic Formulas See Mr Excel and excelisfun use two methods to sum the three biggest values that match three criteria (3 conditions) 1. Advanced Filter and LARGE and MAX value 2. SUM and LARGE…

Post has attachment
Creating an Excel workbook from a template helps save you time because you can use a ready made spreadsheet. Most templates can also be customised once downloaded and saved. HOW TO DOWNLOAD A TEMPLATE Step 1 Click the File tab. Step 2 Click New or search…
Wait while more posts are being loaded