All Microsoft Excel Versions

Backing Up Customized Changes to Toolbars and Menus

The customized changes made to menus and toolbars are saved in a file with the extension .xlb. In Excel 97 and Excel 2000, the file name is the user's...

Calculating the Week Number

To calculate a week number: Use the WEEKNUM function. The second argument in the WEEKNUM function, Return_type, determines on which day the week...

Rounding a Value to Make It Divisible by a Specified Number

Problem: Rounding up each number in column A to the nearest value that makes it divisible by the corresponding number in column B. Solution: ...

Selecting a Set of Random Numbers, Avoiding Duplicates

In this article, we will learn how and where we can generate random numbers without repetition in Microsoft Excel. We need the random numbers when we...

Calculating the Average Growth of a Child

Problem: A child's height has been measured once a year. Columns A & B show the results of these measurements for a period of six years. We w...

Counting the Number of Dates with Matching Month Criteria

In this article,you will learn how to count the number of dates with matching month criteria in Microsoft Excel. To solve this problem, which function...

Calculating the Proportion of Characters from One String that Appears in another String

Problem: Calculating the percentage of the characters from each string in column B that appear within the corresponding string in column A. Solu...

Returning the Nth Largest / Smallest Values in a Range in Microsoft Excel 2010

If we have a list and we want to find the nth largest or smallest number then we can use the LARGE and SMALL functions.   LARGE function: ...

Checking for Sequences within a Sorted List

Problem: List1 (column A) is a series of numbers that has been sorted in ascending order. We want to create a formula that will check whether each n...

Coloring Numbers Based on Specific Criteria Using Conditional Formatting

In this article, we are going to learn how to color numbers, based on specific criteria, using Conditional Formatting in Microsoft Excel. What is Con...

Page 40 of 105« First...102030...3839404142...506070...Last »
Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube