Learn Microsoft Excel Online FreeThis post will guide you how to vlookup to return multiple values in one cell in Excel. How do I lookup and return multiple values concatenated into one cell with an User defined function in Excel. Vlookup to Return Multiple Values in One Cell Assuming that you have a list of data in range A1:B6,… read more »
This post will guide you how to convert multiple rows or columns into a single row with a formula in Excel 3013/2016. How do I convert groups of rows to a single row of columns with VBA Macro in Excel. Convert Multiple Row into Single Row with Formula Convert Multiple Row into Single Row with… read more »
This post will guide you how to hide rows based on cell value in Excel. How do I hide rows based on cell value with VBA Macro code in Excel 2013/2016. Hide Rows Based on Cell Value using Filter Feature Hide Rows Based on Cell Value using VBA Macro Hide Rows Based on Cell Value… read more »
This post will guide you how to automatically update cell with current timestamp when another cell is changed in Excel. How do I insert date and time in adjacent cell automatically when changing cell values in Excel. Insert Date and Time Automatically When Cell Changes Assuming that you have a list of data in range… read more »
This post will guide you how to concatenate text values based on unique values in another column in Excel. How do I concatenate cells based on specific criteria in Excel. Concatenate Text Based on unique Values in Another Column Assuming that you have a list of data in range A1:B6, in which contain product IDs… read more »
This post will guide you how to delete all textboxes from an active worksheet in Excel. How do I delete all textboxes without looping using an Excel VBA Macro. How to delete multiple text boxes in Excel. Delete All Textboxes Using Go To Special Feature Delete All Textboxes Using VBA Macro Delete All Textboxes Using… read more »
This post will guide you how to sum range of cells ignoring Errors in Excel. How do I sum and ignore errors with a formula in Excel. How to sum range ignoring all error values with VBA macro in Excel. Sum Range Ignoring Errors with Formula Sum Range Ignoring Errors with VBA Sum Range Ignoring… read more »
This post will guide you how to replace formulas with their calculated values in Excel. How do I replace all formulas with their values using VBA Macro in Excel. Replace Formulas with Their Values Replace Formulas with Their Values Using VBA Assuming that you have a list of data that contain formulas in range B1:B4,… read more »
This post will guide you how to import data from another workbook into your current worksheet in Excel. How do I copy data from a closed workbook with VBA Macro in Excel. How to insert worksheet from closed workbook into the current workbook in Excel 2013/2016. Import Data From Another Workbook Import Data From Another… read more »
This post will guide you how to convert row data to columns in Excel. How do I convert columns to rows with Paste feature in Excel 2013/2016. Convert Rows to Columns Using Paste Special Convert Rows to Columns Using Formula Convert Rows to Columns Using VBA Convert Rows to Columns Using Paste Special Assuming that… read more »
