Find Number of Duplicates within Multiple Columns
I need to create a COUNTIF formula (I assume) that will count the number of duplicates of a number in at least 10 different columns. I will eventually create a notification for the end result but I can't figure out how to do it over more than one column without only being able to compare the other columns to just one column.
I have combed through many different questions about duplicates and can't seem to find a formula that will work for my situation.
Help Article Resources
Check out the Formula Handbook template!