FREE FILE TO DOWNLOAD: https://jopaexcel.com/comparelistsxbuifdeufxg

In this Excel video tutorial, we will learn how to compare lists in the Excel spreadsheet. Compare data, compare values, compare information.

Learning how to compare lists in Excel can be very important because we can check, for example, the recurrence of purchases from the same customer in each month, we can also check customers who only purchased once and we can also check new customers who are purchasing for the first time So we can do several different checks and analyzes using a list comparison in Excel.

Count if is the function that will help us compare lists in Excel with the countif formula we can count the number of times that something appears within the selected range so we can know how many times the same customer already purchased, we can count the repeated values, we can count the repetitions, we can count the things that are repeated in the exception spreadsheet and we can also see the new appearances, that is, the things that are appearing for the first time, new customers in this way.

#JopaExcel #Dashboard #Excel