excel Question about Excel!

[FMH]

Hi! I have a query regarding MS Excel. I have the 2016 version. 

 

So I have this really large data with four columns. Name, cell number, gender and email. What I want to do is filter out any cell number that was used more than once from my data. I don't just want to remove duplicates, I just want to consider cell numbers that were only used once in the entire sheet. There are some cell numbers being used multiple times that I don't want to consider. 

 

Can anyone please tell me  how I can do that?

[FMH]

.

[+virtorio MVC]

https://support.office.com/en-us/article/Filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2

[FMH]

18 hours ago, virtorio said:

https://support.office.com/en-us/article/Filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2

Thanks! That didn't do exactly what I was looking for! But I found a free extension for Excel called KuTools that does what I was looking for! Thanks for the help though! 

[TDT]

26 minutes ago, FMH said:

Thanks! That didn't do exactly what I was looking for! But I found a free extension for Excel called KuTools that does what I was looking for! Thanks for the help though! 

You should really check out all the features of KuTools, it's really great, it saved me more than once

[FMH]

3 hours ago, TDT said:

You should really check out all the features of KuTools, it's really great, it saved me more than once

Yea! It's much easier to filter and select on KuTools without knowing fancy formulas

[+Zlip792 MVC]

10 hours ago, FMH said:

Thanks! That didn't do exactly what I was looking for! But I found a free extension for Excel called KuTools that does what I was looking for! Thanks for the help though! 

It is not free but only 30 day trial with full features as per website.

[FMH]

34 minutes ago, Zlip792 said:

It is not free but only 30 day trial with full features as per website.

Oh dear! XD I didn't know that, I'll ask my company to pay for it in that case