The Excel IF () function returns “Duplicate,” when the Excel function, COUNTIF () finds more than one occurrence of the concatenated values in column H. Figure F Image: Susan Harkins/TechRepublic.

3] To Find the Maximum Value Choose the cell below or right, then go to the Auto-Sum Tool in the Editing Group and select the Max Function; it will automatically give you the result. Or you can ...

Image: iStock/panimoni Microsoft Excel’s Find feature is one of its most flexible tools in the entire toolbox. You can do much more than just find and replace data. For instance, you can use it ...

If you can't find the terms or numbers you're looking for, be sure to double check the way you typed them into the search bar; Excel won't look for similar terms, so a mistype ruins the effort.