How to Delete Blank Rows at Bottom of Excel Sheet

Deleting unused blank rows from a sheet can help you reduce file size significantly and make your dashboard cleaner. In this article we will learn...

How to validate only numbers in cell in Excel

In this article, we will learn How to count values in a cell in Excel. Scenario: Data validation tool restricts the user to input data to en...

How to use data validation with no punctuation in Excel

In this article, we will learn How to use data validation with no punctuation in Excel. Scenario: Data validation tool restricts the user to...

Can't Update Some of The Links in Workbook Right Now! How to solve it?

When you work with multiple workbooks in a business, you import data from various external data sources. The external source can be another excel ...

How to Count missing values in list in Excel

In this article, we will learn about how to look up missing values in the table in Excel using the formula shown in the above image. Scenario: ...

Price SUM by weekdays in Excel

In this article, we will learn to return the price SUM by weekdays in Excel. Scenario: In simple words, while working with price filled data. So...

What To Do If Excel SUMIF Is Not Working?

The SUMIF function is a useful function when it comes to summing up values based on some given condition. But there are times when you will face s...

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.