Formulas

Often we face a situation where we need to get first and last word from a cell/text string in Excel.Let’s say… …you want to extract the first name from……a cell where

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

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

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

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

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 one of