Sorting out duplicate phone numbers in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database of approximately 10,000 of various companies and phone numbers, some are repeat numbers throughout. Is there a formula or function that will allow me to sort or review a column and remove duplicate phone numbers?

Thanks you.
 
There is no method/function in .NET that you can use, but you can write SQL statement to find that out. Look at GROUP BY and COUNT keywords for SQL.

Tu-Thach
http://www.ongtech.com

----- Smack wrote: -----

I have a database of approximately 10,000 of various companies and phone numbers, some are repeat numbers throughout. Is there a formula or function that will allow me to sort or review a column and remove duplicate phone numbers?

Thanks you.
 
Back
Top