-
Continue reading →: SEARCH RANGE FOR TEXTOften we need to search a range for a specific word. The result we want is whether the word is present or not. To check if a value or a substring is present in a range we can use the SEARCH function. We will then combine this with the ISNUMBER…
-
Continue reading →: Value exist in range or notIn Excel we often want to check weather a value exists in a given range or not. As usual, there are multiple ways to do this. In this part, we will make use of the =SUMPRODUCT() function. Below we have a given list of fruits in column F. In column…
-
Continue reading →: EXCEL SUMPRODUCT – PART 2In the previous post we saw how we can use SUMPRODUCT to calculate products. Another feature of this function is that it allows us to specify a calculation on just part of a column. For example, only IDs that start with 123. In the previous post we calculated the total…
-
Continue reading →: EXCEL SUMPRODUCTExcel SUMPRODUCT multiplies ranges together and returns the sum of products. Lets make an example to calculate total sales. Below we have some fruits, price per fruit, and total quantity. Our goal is to calculate the total sales. One way to do this is E5*F5 and drag it down. Then,…
-
Continue reading →: EXCEL INDEXThe INDEX-function is used to return a value or a reference to a value. It is mostly used in combination with other functions, like the MATCH function. Lets see how this works with a simple example: We have two columns with data, here we want to return a color of…
-
Continue reading →: HIGHLIGHT CELLS THAT CONTAINSometimes it is good to highlight specific words or sentences in Excel to make the user aware of something specific. It can be a specific group or ID for example. Below we have a list of fruits in Column A, we want to highlight all the cells that contain the…
-
Continue reading →: SEARCH FOR VALUEA common task in Excel is to find out if a certain value exist in a list or not. There are multiple ways to achieve this. In this post, we are going to use a combination of IF and COUNTIF-function. Above in column C we have a list of values.…
-
Continue reading →: HIGHLIGHT MISSING VALUES IN EXCELA common task in Excel is to spot differences between list or compare them in some way. Here we are going to highlight values that are missing in one list. There are multiple ways to do this – here we are going to use conditional formatting. Above we have two…
-
Continue reading →: SEACRH LIST FOR MISSING VALUESIn Excel we often want to search for a specific item or value, when that specific value does not exist, we want to get a notification about that. Above we have a bunch of IDs in column B, in column D we have another bunch of IDs that we want…
-
Continue reading →: How to fix VLOOKUP returning #N/A ErrorWhen we are using VLOOKUP to find a value, and Excel cannot find the value, it usually returns #N/A We can use different ways to catch this error and return any value. As in our previous post we are going to use =IFERROR() Lets play with some example-data Above we…
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Excel tutorials 