17,192 views
🟢 LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... In this free Excel video lesson, we will learn how to Compare Lists in Excel to Find Repeated Values and missing values. We will use the Countif function in the Excel spreadsheet or the countif formula in Excel. Thus, we can find Duplicate Values with Several different Criteria in our tables. How to check if there are repeated values between two lists in Excel, how to check the repetition of values between two spreadsheets in Excel, how to Check repeated values between tables, how to check the repetition of information in Excel between different spreadsheets, etc., I hope to be able to answer all these questions in this free Excel tutorial step by step from scratch. I hope it can help you a lot in your day to day life and in the job market to automate tasks and automate processes and save time with Excel. Regardless of how many different spreadsheets you have, you will be able to connect these spreadsheets and check the repeated values that appear in one spreadsheet and also in another, the repeated values that appear in more than one spreadsheet. We will use one of the most important Excel functions, one of the most important Excel formulas, count.if, count with criteria. The count.if formula or count.if function, instead of counting all the selected values, like count.values, it will only count the values corresponding to the determined criterion, it will only count the values corresponding to the criterion you choose. This way, we can count everything that exists in a list and check if it is equal to what exists in the other list and see the count. If it is equal to zero, one, two, three and so on. Anything that is greater than zero indicates that there is already a repetition, anything that is equal to zero indicates that there is no repetition, since the value does not appear once in the other list. #ExcellentJoão #Excel #Dashboard