Find All Cells that have Data Validation in Microsoft Excel 2010

In this article, you will learn how to find all the cells that have data validation & find out same data validation. While working on large wor...

Dynamically Filter Data from One Worksheet to Another in Microsoft Excel 2010

In this article, you will learn how to get dynamically filtered data from one worksheet to another using Microsoft Query.   Let us understand w...

Copy Data from One Sheet to Another Using Worksheet Function in Microsoft Excel 2010

In this article, you will learn how to copy data from one sheet to another using worksheet function.   Let us understand with an example: ...

Conditionally Format Row above Matched Text Criteria in Microsoft Excel 2010

In this article, you will learn how to format row above the matched criteria. For example:     The criterion is to look for text Subtotal i...

Automatic Sorting as you Enter Dates Using VBA In Microsoft Excel 2010

In this article, you will learn how to automatically sort dates as you enter in the worksheet. Q) I have a spreadsheet that's getting updated with ...

SUMIF Using Text Criteria & Wildcards in Microsoft Excel

We know how to sum one column on multiple conditions. We use the SUMIFS function. But how do we sum multiple columns in one condition. This article is...

How to Retrieve Text Before Specific Character in a String in Microsoft Excel 2010

In this article, you will learn how to extract all text strings before a specific text. If there is a requirement to retrieve the text from a column b...

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 Youtube