Learn Microsoft Excel Online FreeThis post will guide you how to copy and paste only non-blank cells in Excel 2013/2016. How do I copy only non blank cells with VBA code in Excel. Or how to get non-blank cells from a range of cells with a formula in Excel. This post will introduce four methods to copy and paste… read more »
This post will guide you how to get a list of all worksheet names in an excel workbook. How do I List the Sheet names with Formula in Excel. How to generate a list of all sheet tab names using Excel VBA Code. Assuming that you have a workbook that has hundreds of worksheets and… read more »
This post will guide you how to convert weekday string to number in excel. How do I convert weekday name to number with a formula in excel. How to convert day of week to number in excel. Is there an easy way to convert a weekday string which is either “Monday” or “Tuesday” into a… read more »
This post will guide you how to find the maximal and minimal value or string from an alphanumeric data list in excel. How do I retrieve or get the max or min string value based on alphabetic order from a string data in excel. For example, if you want to find the Maximal or minimal… read more »
This post explains that how to check a cell that contains one of several values in another range, and then return the last match value. And we talked that how to test a cell to see that if it contains one of several values in a list in the previous post. And this post will… read more »
This post explains that how to lookup the value in a table or a range based on the multiple criteria in excel. This post will guide you how to search for a specified value with multiple criteria using INDEX and Match functions. And how to use Lookup function to lookup the value with multiple criteria…. read more »
In the previous post, we have talked that how to get the position of the last occurrence of a specific value in a single range or column. And this post will guide you how to get the position of the last occurrence of a character or text string in a Cell using below two ways… read more »
This post will guide you how to use Excel LOOKUP function with syntax and examples in Microsoft excel. Description The Excel LOOKUP function will search a value in a vector or array. The LOOKUP function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The LOOKUP function is available… read more »
