Question about Microsoft Office Standard for PC

1 Answer

Locating provinces per area


i've been looking for easier solution on my prob., hope you could help me guys. i have thousands of list from different areas, provinces and different towns. Now i have to consolidate each town per provinces per town. my raw data will be tel numbers., For better understanding here are some sample data:

Pangasinan CENTRAL---------------- Bayambang
San Carlos
Pangasinan EAST-----------------------Binalonan
Rosales/ Carmen
Pangasinan WEST-----------------------Alaminos

Raw DATA: Telephone NUMBERS with given TOWN

what i really want, Enter the town in a cell then it will automatically search for particular province, in a particular area (central or west or east or south)

hope you could help me guys...PLEASE

Thanks a LOT!!!


Posted by on


1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

You can return the Province using a LOOKUP function either V or H depending on how your have sorted your data of towns per province.

Posted on May 22, 2009


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

How do i find the list of options that came with my car?

u could look on ur glove box door. theres usually a tag with sets of numbers prob 5 6 0r 7 rows of numbers in sets of threes .also check on ur spare tire cover or inside trunk area prob even on back of trunk door depending wat make of car u own... hope this is helpful

Jun 28, 2015 | 2002 Honda S2000

1 Answer

Hello my name is steve i have a early yamaha jetski vxr pro 700 i bought for my son we got it just before xmas it starts up no probs just when you get going it goes well but after about a minute the power...

I am not an expert in jet skies but just a thought. Did you check that your fuel pump works good? Test the pump for quantity per 10sec according to the service manual. It may just gone bad. Good luck and hope I've helped.

Feb 06, 2012 | Motorcycles

1 Answer

What is the zip code of philippines

That would depend on which part of the Philippines you need the zip code for. They are usually 4 digits.The Philsite Zip Code Directory will help you locate the zip code you need. It has telephone area codes, maps and alphabetical lists for the zip codes of ALL cities, ALL provinces and ALL Metro Manila Municipalities.

It doesn't look like they left anything out so as far as the codes are concerned, there's probably nothing that you would need that this website doesn't have.

Sep 02, 2011 | Computers & Internet

1 Answer

When I type in Ontario looking for province it comes up "no match found" so cannot proceed with address function. . I have brand new garmin 1300


If you are searching for provinces in Canada you must also have Canada selected as your country. So when selecting your province of choice also make sure that the country you have selected is Canada. If your unit is a 1300 it would not have came with an Canadian database. Check your map information do this by going to Tools > Settings > Map > Info you will be able to ell from here if you have Canadian mapping or not.

Hope this helps!

Mar 22, 2011 | Garmin nuvi 1300 Car GPS Receiver

2 Answers

My mblaze is always blinking becomes too slow

I think your network is not strong.or cross the download limit.
Hope this helps.
There is an rate option "Was this helpful?" Yes or No.
If you are helped you can rate ,that is your choice.

Jan 17, 2011 | Computers & Internet

1 Answer

I ordered age of mythology the titans expansion from you guys, when i try to play online, it says your cd key cannot currently be validated, i looked online and the same cd key you gave me was on the...

Who is "you guys"? I don't think FixYa sells games. You can ask the person who sold it to you for a refund, since Ensemble Studios only allows one unique CD key per person.

Jul 29, 2010 | Video Game Consoles & Games

1 Answer

Water is not being sent through the arm/blades during the wash cycles.

More than likely the water pump control has gone out.Due to the location of this part it would be easier to have a tech look at it since the pump is located in an akward area
Hope this helped


Feb 08, 2010 | Dishwashers

1 Answer

1. I'd like to change the setting so that the most recent email messages are on top of the list (rather than the bottom) 2. Instead of having 25 or 50 email messages per page, I'm getting the whole list...

Hello EM,

From your main Yahoo! Mail window:

1) Click "Options" > Select "Mail Options"

2) Click Accounts > Highlight the account you wish to change

3) Click "Edit" button

Under Folders heading find:

Message ordering: Put dot in "Descending by date" - your new messages will appear at the top

Messages per page: Choose 10, 25, 50 etc.

Change any other options to your liking, then click the "Save" button in the upper left or lower left corner.

I hope you found this information helpful!

Jan 12, 2010 | Yahoo Mail

2 Answers

How do I change the turn signal bulb on 2000 Ford Mustang

Actually its easier that what the other guy said. lift your hood, look at the headlight there will be two rods that u can pull on the top of the light where it sits in the frame. pull those and u can then pull your headlight out, that will make it alot easier to get to.

Hope This Helps.

Mar 22, 2009 | 2000 Ford Mustang

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

93 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2934 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18413 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides