Get First and Last Word
Often we face a situation where we need to get first and last word from a cell/text string [...]
How to Count Unique Values in Excel [Formulas + VBA]
Let’s say you have a list of values where each value is entered more than once.And now... You [...]
How to Create a Step Chart in Excel
A step chart is a perfect chart……if you want to show the changes…happened on irregular intervals.And that's why [...]
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 [...]
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 [...]