All Microsoft Excel Versions

Summing Sales Amounts According to Product Category and Customer Name

Problem: Columns A:C contain product categories, customer names, and prices paid for various items. When using the following formula to sum the pric...

Simplifying Formulas by Defining Names for Often-Repeated Parts

Problem: The following formula searches column A for each of the serial numbers listed in column C. It then analyses the corresponding number from...

Removing duplicate values by comparing values in two consecutive columns

  In this article, we will create a macro to check duplication and remove duplicate values from two consecutive columns. Raw data consists of t...

Retrieving the Value of the First Nonblank Cell in a List

To retrieve the value of the first non blank cell in a list, we will use Index and Match functions. Why and how we use Index and Match functions toge...

Counting Values that Appear Only Once in

Problem: Counting the number of values in List1 (column A) that appear only once within the list. Solution: Use the SUM, IF, and COUNTIF func...

Find method of Range object

In this article, we will use find method of Range object to highlight the cell which contains the value similar to search words. Raw data for...

Counting the Number of Times a Specified Substring Appears within a Range of Strings

Problem: Counting the total number of times each of the substrings listed in column B appears within any of the strings in column A. Solution: ...

Counting Rows of Even Numbers in Two Parallel Ranges

In this article, we are going to learn how to count rows of even numbers in two parallel ranges in Microsoft Excel. To solve this problem, we will us...

Creating a List in which Each Number is the Sum of the Previous N Numbers

Problem: We want to create a sequence of numbers where each member of the sequence is the sum of the previous N number of values. Solution: U...

Counting the Number of Players According to Their Score in a Particular Quarter

Problem: Finding the number of players (column A) who scored over 3 points (column C) in the first quarter (column B). Solution: Use the SUMP...

Page 30 of 105« First...1020...2829303132...405060...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