Using the Exact Formula to Compare 2 Sets of Data in Excel скачать в хорошем качестве

Using the Exact Formula to Compare 2 Sets of Data in Excel

In this video, I show you how to use the EXACT formula in Microsoft Excel 2016 (similar in most versions) to compare two sets of data to determine whether they match or not. In this example, I compare two sets of fictional item numbers to locate which ones have been changed and which are the same. This is handy to use when comparing item descriptions, names, addresses, or other data in which there are two sets of text or numbers that you want to find out whether they match or not. Also shown is sorting and pasting values. Don't forget to subscribe to my channel for more tutorials! Video recorded using Screencast-O-Matic (http://www.screencast-o-matic.com) Thanks for tuning in!