I have a sheet with students details on and some of them appear more than once. All I want to be able to do is count the number of names that appear in the list excluding dupes ie if a column has Matthew, Mark, Luke, Luke, Luke and John then I just want it to count the number of unique names so the answer would be 4 in this case. I am sure it is a simple thing but I just cant figure it out! Can anyone help?