Use Wildcards with VLOOKUP

how to use wildcards with vlookup in excel

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

how to sum values between two dates in excel

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. Here, you have a range of dates which actually includes total 15 dates and […]

Check it out now

Get Last Day of a Month

how to get last day of a month

Sometimes you need to use the last day of a month in a calculation as a completion date, due date, or as a target date. You can easily add a month’s last date manually but there are some formulas which can help you calculate it. And, the best way to calculate it by using EOMONTH […]

Check it out now

Create a Step Chart in Excel

how to create a step chart in excel

A step chart is perfect to use when you want to show the changes happened on irregular intervals. It can help you to present the trend as well as the actual time of a change. In real, a step chart is an extended version of a line chart. Unlike line chart, it doesn’t connect data […]

Check it out now