Need to calculate number of repeat customers in an alphabetic list.

[sethover89]

I am creating a working template spreadsheet for a small business owner, and she would like to see how many repeat customers she is getting. I have built a table that has the customers names on one column sorted alphabetically. Just curious if I can write a formula that will countif. The way that it would count if is it would count only if that persons name shows up more than once in the whole column with names. I havn't found anything identical to this in the forums, so hopefully i'm not repeating a past post. Thanks for looking and I will attach a photo of the document now.

 

[sethover89]

http://1drv.ms/1DAhesn

 

[vllgv]

=if(countif(customerlist,customer)<1,"",counif(customerlist,customer))

 

[sethover89]

=if(countif(customerlist,customer)<1,"",counif(customerlist,customer))

Thanks man that seemed to have worked! Your Awesome!