Hi

I have a list, 50000 rows long with phone numbers and the service provider it belongs to. I want to extract some of this information.

I'm looking for a formula which can give me the following:

How many unique phone numbers is there in column B from service provider number 4 and 5?

The following pic is just an example of how the list is compiled.

How can I get sum up only the numbers from 4 and 5 and not the whole bunch?

If I use this formula

Try this formula. Array formulas will have curly brackets {} emcompassing the ENTIRE formula. You do not add these, you Enter the formula with Ctrl+Shift+Enter and Excel will add them (details: Array formulas). Many more Excel Formulas

I sum up all the unique phone numbers, but I don't know how to set a "if service provider is 4 or 5" if you get what I mean.

This was the first part.

The second part is finding out how many times each unique number from service provider 4 and 5 is listed.

I greatly appreciate any help I get from you guys.

Thanks

I have a list, 50000 rows long with phone numbers and the service provider it belongs to. I want to extract some of this information.

I'm looking for a formula which can give me the following:

How many unique phone numbers is there in column B from service provider number 4 and 5?

The following pic is just an example of how the list is compiled.

How can I get sum up only the numbers from 4 and 5 and not the whole bunch?

If I use this formula

Try this formula. Array formulas will have curly brackets {} emcompassing the ENTIRE formula. You do not add these, you Enter the formula with Ctrl+Shift+Enter and Excel will add them (details: Array formulas). Many more Excel Formulas

=SUM(N(FREQUENCY(D1:D51112,D1:D51112)>0)) |

I sum up all the unique phone numbers, but I don't know how to set a "if service provider is 4 or 5" if you get what I mean.

This was the first part.

The second part is finding out how many times each unique number from service provider 4 and 5 is listed.

I greatly appreciate any help I get from you guys.

Thanks

## Comment