In this video I will explain how to prevent duplicate data input in excel. Preventing duplicate data in excel so that when inputting data such as the example, the same invoice number is immediately double detected, making it easier for us to work, especially when processing data that has so many rows. I have included the double data formula in excel and the explanation so that later it will be easier for friends to understand the writing of the formula. Hope it is useful....