Learn Microsoft Excel Online FreeSometimes we may want to sum the largest N numbers or top N numbers in a range. In this article, we will show you the method of “SUM the Largest N Numbers” by a simple formula which consist of SUMPRODUCT and LARGE functions. LARGE can return largest values based on criteria, SUMPRODUCT can sum up… read more »
Sometimes we may want to sum the first smallest N numbers in a range in Excel. In this article, we will show you the method of “SUM the Smallest N Numbers” by a simple formula which consist of SUMPRODUCT and SMALL functions. SMALL can return smallest values based on criteria, SUMPRODUCT can sum up these… read more »
This post will guide you how to count a non-contiguous range with criteria in COUNTIF function in Excel 2013/2016 or Excel office 365. How do I build a formula for counting non-contiguous range in Excel using COUNTIF function in Excel. What is Non-Contiguous Range? A non-contiguous range consists of tow of more separate ranges in… read more »
This post will guide you how to count number of occurrences in whole workbook in Excel 2013/2016 or Excel office 365. How do I count how many times a string is repeated in all worksheets in Excel. You may be want to count occurrences for the number of times a certain value matches across all… read more »
This post will guide you how to remove all numbers from a text string in one cell in Excel. How do I strip all numeric characters from a given cell with a formula in Excel. How do I remove numbers from cells with text using a User Defined Function in Excel. Remove Numbers From Text… read more »
This post will guide you how to convert column letter to number in Excel. How do I convert letter to number with a formula in Excel. How to convert column letter to number with VBA macro in Excel. How to use a User Defined Function to convert letter to number in Excel. Convert Column Letter… read more »
This post will guide you how to copy value from same cell on multiple worksheets in your workbook in Excel. How do I List values of same cell reference from multiple worksheets with a formula in Excel. How to copy data from the same cell of multiple worksheets with VBA Macro in Excel. How to… read more »
This post will guide you count a value across multiple worksheets in excel. How do I use COUNTIF function to get the number of occurrence of a value from multiple worksheets in Excel. How to count the number of values from multiple worksheets in Excel. How to count based on a single criteria across multiple… read more »
This post will guide you how to reverse text string in Excel. How do I reverse text string in one cell with an Excel User Defined Function. How to reverse a text string in one cell with a formula in Excel. Reverse Text String with User Defined Function You can easily write down a User… read more »
This post will guide you how to remove non numeric characters from cells with a formula in Excel. How do I remove non-numeric characters in cells in Excel. How to remove non-numeric characters from cells with VBA Code in Excel. Or how to strip out non-numeric characters from a given cell in Excel. Removing Non… read more »
This post will guide you how to sum the numbers from 1 to N in Excel Worksheet. How do I sum the integers from 1 to N with an excel formula. How to write an excel formula to calculate 1+2+3+…+N in excel. Normally, we can use the SUM function to sum a list of numbers… read more »
This post will guide you how to create 3d references to conditionally sum identical ranges that exist in the multiple sheets, and make it all in only one formula. How do I create a formula to sumif with 3d reference for multiple worksheet based on multiple criteria in excel. Sumif with 3D Reference for Multiple… read more »
This post will guide you how to retrieve values using references based on Row and Column numbers in excel. How to get the cell value based on row and column numbers with an excel formula or user defined function in excel. Get Cell Value Based on Row and Column Numbers If you want to retrieve… read more »
This post will guide you how to convert a column letter to a column number using an excel formula. And how to write a user defined function to convert column letter to number in excel VBA. Convert column letter to number using excel Formula If you want to convert a column letter to number, you… read more »
This post explains how to return an array of numbers using an excel formula in excel. Create an Array of Numbers If you want to create an array of numbers, you can use a combination of the ROW function, the INDIRECT function or OFFSET function or INDEX function or MIN function to create a new… 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 explains that how to convert the text to an Array in excel. How to convert text into array using formula in excel 2013? How to split the text string into an array where the each character in text is an element in array using excel formula in excel 2013. How to split text… read more »
This post explains that how to remove non-numeric characters (numbers) from a text string in one cell in excel 2016. How to remove non numeric characters from a cell containing text string with an excel formula. And how to remove alphanumeric characters from a cell with a user defined function in excel VBA. Remove non… read more »
This post explains that how to remove numeric characters (numbers) from a text string in one cell in excel 2016. how to remove only numeric characters but keep the non-numeric characters from a cell containing text string with an excel formula. And how to remove numbers from a cell with a user defined function in… read more »
This post will guide you how to use Excel INDIRECT function with syntax and examples in Microsoft excel. Description The Excel INDIRECT function returns the cell reference based on a text string, such as: type the text string “A2” in B1 cell, it just a text string, so you can use INDIRECT function to convert… read more »
