In the previous article, I told you how to use the excel advanced filter and the remove duplicate menu to remove duplicate rows in excel. In this article, I will tell you how to use a formula to filter out duplicate rows in excel and remove them.
This article will show you examples of how to count the number of cells which contains either value X or value Y. It will also show you examples of how to count cells contain both value X and value Y.