Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.

Combine INDEX and MATCH: Use MATCH to find the row or column number and INDEX to retrieve the value at that position.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

How to multiply multiple numbers from several cells in Excel There may come a time when you feel the need to multiply numbers that are situated in different cells. The question is, how do we do this?