IFERROR with VLOOKUP

While using VLOOKUP, whenever the value for which you are looking for is not there in the data you get #N/A error. In simple words, whenever VLOOKUP is not able to find the value it returns #N/A. For example, you have a list of employees name and you want to lookup for the name “John”. […]

Check it out now

Convert Negative Number into Positive

Last week, I got a mail 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 […]

Check it out now

MAX IF Formula

Ever tried to get max value from a range using a specific condition? Which formula do you think you can use? No idea?Let me tell you.Well, in excel, there is no specific function for this (unless you are using office 365), but, you can combine MAX and IF function to create a formula which can […]

Check it out now

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

get first and last word from a text string

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
1 2 3 24