Last week, I got an email from one of my subscribers with a question.Hey Puneet, how many methods we have to convert a negative number into a positive?You know, the thing for which he asked is a common kind of task.I am sure, this often happens with you, when you get some numeric values which […]

Often we face a situation where we need to get first and last word from a cell/text string in Excel.For example, let’s say you want to extract the first name from a cell where you have both first and last names or you want to extract product name from the product description cell.We do need […]

Using wildcards with VLOOKUP can be super useful for you. It can help you to look up for a value using a partial match. Let’s say you have data like below table where you have students full name in one column and their marks in another column. Now from this data, you want to lookup […]

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 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 […]

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 […]