Excel provides many formulas for finding a particular string or text in a list or array.  In this video, you will learn how to use the MATCH function. Excel defines MATCH function as “Returns the relative position of an item in an array that matches a specified value in a specified order”. In simple plain language Match function searches for a value in a defined range and then returns its position. You will definitely love this video as it not only shows how to compare 2 lists but also demonstrate 2 ways how to handle errors when the comparison finds [More]
Excel! See how to add Conditional Formatting to a whole row of data. See that the formula for this is a True/False formula. Then see how as you change the input, the conditional formatting magically updates! See how to do this lightening fast with keyboard short cuts!
 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.