Hey everyone, im wondering how i can count how many cells in a certain collumn are occupied.
for example, in Collumn A I have a list of phone numbers that begin with 519, and in collumn B i have a list of phone numbers that begin with 416. I need code that can count how many cells in collumn A are occupied (to see how many 519 phone numbers there are) and have that number displayed in M1.

Thanks :D