I'm not sure what you are trying to do since your "if I have" example
exactly matches your "I need to return" example.

Are trying to get excel to count the number of duplicate entries?
If that's the case us =countif(A:A,A1)
(If the addresses are listed in Column A