Find Maximum if multiple criteria in Excel

In this article, we will learn about how to find the Maximum value if it matches multiple conditions in Excel.  Scenario: When working with l...

find the last column of data in Excel

In this article, we will learn to return the Last column of data in Excel. Scenario: In simple words, while working with long unmannerly data,...

Reference Isn't Valid Excel Error and How to Solve It?

"Data source reference is not valid" is one annoying problem that can be hard to get rid of, if you don't know the source problem. In this article...

13 Methods of How to Speed Up Excel

Excel is fast enough to calculate 6.6 million formulas in 1 second in Ideal conditions with normal configuration PC. But sometimes we observe exce...

Why is My Excel File So Large? How to Reduce the Excel File Size?

Excel is an amazing tool for analyzing and visualizing  data sets. To visualize and make report we often need to save small chunks of data. These...

What to do If Excel Break Links Not Working

When we work with several excel files and use formula to get the work done, we intentionally or unintentionally create links between different fil...

Data validation with specific Hour, Minute or Second in excel

In this article, we will learn How to validate time entries which contain specific hours, specific minutes or specific time using data validation in...

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