Need help with Excel Sheet

mon3y4me · Mar 15, 2020

Hi guys,

I have an excel file and it has mixed data from various countries. I'd like to filter the data and remove all rows from the column with foreign phone numbers. I want to keep only the ones which has numbers from usa, ca and uk country. How can I do this without having to do it one by one? I know you can apply rules to excel, but I'm not sure which one it is. If someone could help me, i'd appreciate it. Thanks

Repulsor · Mar 15, 2020

You can sort by phone numbers and then remove the unwanted. Or you can do it programmatically.

Power Booster · Mar 15, 2020

Are the numbers contain the phone number code also?

mon3y4me · Mar 15, 2020

It looks like this, i want to remove the ones that don't start with +1 and +44 along with the other columns

warmember · Mar 15, 2020

if you cant find out how you can always pay someone on fiver to do it and give them a copy spreadsheet

JFT96 · Mar 15, 2020

Custom Filter on the phone coloumn.

But, you're not doing the Support Center scam, are you?

mon3y4me · Mar 16, 2020

JFT96 said:
Custom Filter on the phone coloumn.

But, you're not doing the Support Center scam, are you?

No, its not anything like that. What function will be used for that?

brokerUS · Mar 16, 2020

Highlight the top row then
Data > Filter
Then use the drop down on that column and you can filter not including xxx

Need help with Excel Sheet

mon3y4me

Elite Member

Repulsor

Senior Member

Power Booster

BANNED

mon3y4me

Elite Member

Attachments

warmember

BANNED

JFT96

Newbie

mon3y4me

Elite Member

brokerUS

Junior Member

Main Menu

Marketplace

Making Money

BlackHat World