Shares

## Convert Formula to a Static Value

From the starting days of my job, I have learned one thing hard way that before sending a report to someone we must convert all the formulas into values.I have faced this problem so many times that after sending a file to someone, he/she made a change (mistakenly) into it and then they say, “there […]

Check it out now

## Get First and Last Word

Often we face a situation where we need to get first and last word from a cell in excel. For example, if you want to extract the first name from a cell where you have both first and last names or if you want to extract product name from the product description cell. But in […]

Check it out now

## Use Wildcards with VLOOKUP

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

Check it out now

## 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 in the list. For this, you need to use a method which will count a […]

Check it out now

## Sum Values Between Two Dates Using SUMIFS

Let’s say, you are working in a trading company and your boss tells you to get the total sales amount for last 15 days.In this case, you need to sum sales amount from the current date to 15 days prior i.e. between two dates.Which formula would you use?No idea?Well, if you ask me, SUMIFS is […]

Check it out now