User Posts: Sourav Kundu
0
How to Count Unique Values in Excel with Multiple Criteria
0

In this article, we will show you some methods to count unique values in Excel worksheet based on different criteria. The Excel worksheet can be used to count ...

0
How to Ignore Blank Cells in Excel Sum (6 Ways)
0

This article will show you how you can ignore blank cells in Excel sum. In the spreadsheet, sometimes we have to sum a data range that has blank cells. So, ...

0
How to Use Custom Autofilter in Excel for More Than 2 Criteria
0

Excel spreadsheet can be used for custom autofilter for more than 2 criteria. This filter option is particularly useful for sorting a dataset. In this article ...

0
How to Calculate Absolute Deviation in Excel (2 Useful Examples)
0

Absolute Deviation is a useful tool that indicates the variability of a dataset. It gives a sense of idea about a dataset whether it is clustered or spread or ...

0
How to Use DMAX Function in Excel with Multiple Criteria
0

The DMAX function is used for finding the maximum value of a column or field under multiple criteria. In this article we will show you how you can use the DMAX ...

0
How to Insert Proportional Area Chart in Excel (4 Easy Steps)
0

Charts are useful tools that can be used for representing data in an Excel worksheet. We can also use Area Charts to display the data charts in a proportional ...

0
[Fixed!] Error 509 in Excel (4 Possible Solutions)
0

Error 509 in Excel also known as runtime error(bug). Before releasing the final product to the public, Software developers generally work through different ...

0
How to View Properties Dialog Box in Excel (2 Quick Ways)
0

The properties dialog box reveals the basic information about an Excel file. The file size, its location, name of the author and many other elementary ...

0
How to Calculate Vector Multiplication in Excel (2 Useful Examples)
0

For scientific analysis we may have to calculate vector multiplication. We can use the Excel spreadsheet for this multiplication. In this article, we will show ...

0
How to Perform Employee Scheduling Algorithm in Excel
0

We can perform employee scheduling algorithm in Excel using the in-built Solver feature. This algorithm is particularly handy when it comes to efficient ...

0
How to Perform Custom Scaling in Excel (3 Easy Ways)
0

In this article, we will show you how you can perform custom scaling in Excel to control the print area. When it comes to printing an Excel spreadsheet, many ...

0
How to Create Data Visualisation in Excel (7 Practical Examples)
0

Excel spreadsheet is extensively used for data analysis. Also Excel provides many inbuilt features for insightful data visualisation. In this article, we are ...

0
How to Find Maximum Likelihood Estimation in Excel
0

The maximum likelihood analysis is widely performed in statistical and scientific analysis. This estimation is used for finding the likelihood of a certain ...

0
How to Perform Building Estimation and Costing in Excel Sheet
0

For building a house, it is important to estimate the total cost. This estimation can be very complicated if you try it manually. You can use an Excel sheet ...

0
How to Create Timer Event with VBA in Excel (with Easy Steps)
0

A timer in Excel is used for counting down time. For practical purposes you may need to create this timer event option in Excel. There are several ways for ...

Browsing All Comments By: Sourav Kundu
  1. Hey Yann, we have tried your formula. But unfortunately, this formula is not working as you said it would. It gives a Value error instead.

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo