Find the duplicate and unique Names in the SalesRep Column
Your answer should return Duplicate if the name exists more than 1 time other unique
Use COUNTIF Formula/Function to get the frequency of every SalesRep & Use if Condition for Conditional answer.
USE FUNCTION IN VIDEO
The range of cells to count.
The Criteria thats Control which cells should be counted
=IF(logical_test, value_if_true, [value_if_false])
The condition you want to test.
The value that you want returned if the result of logical_test is TRUE.
The value that you want returned if the result of logical_test is FALSE.