Category Archives for Formulas

How to Count Unique Values in Excel

Let’s say you have a list of values where each value is entered more than once.And now, you want to count unique values from that list so that you can get the actual numbers of values which are there.For this, you need to use a method which will count a value only one time and […]

Get End of the Month Date

Sometimes we need to get an end of the month date to use as a completion date, due date, as a target date or sometimes we need it to calculate the days between two dates.Without any efforts, we can easily add it manually, but there are some formulas which can help us to calculate it.The […]

How to Get Month from a Date in Excel

Dates are an important part of data.There are few times when we need to use only a part from a date. Take an example of the month.Sometimes you only need a month from a date.A month is one of the useful components of a date which you can use to summarize data and when it […]

How to use OR Logic in COUNTIF/COUNIFS in Excel

A few days back I wrote about how we can use SUMIF OR. And today, I want to show that by using same logic we can create a COUNT OR formula.Even we can create dynamic criteria in this formula.But first of all, let me ask you something.Have you ever faced a situation where you need […]

Remove Extra Spaces

A clean data is our birthright. But sometimes, we are not able to access it. Sometimes, we are not able to use our data as the way we want. And, the of the one biggest reasons which make our data unable to use is extra spaces in a cell. So, if you want to use […]

1 3 4 5 6 7 9