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 expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (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:

4 Answers

How do I import Entourage archived .rge files into windows outlook 2013?

Jan 28, 2015 | Microsoft Outlook 2013 Software, English,...

1 Answer

My drivers license expired on 09/01/2014. do i have to take written test again and how can i take care of this

That depends on the laws of your country, province, or state. Please contact the appropriate driver's license issuing agency.

In this case 'product' would have been 'driver's license'. It would have been nice had you also named the country, province, or state.

Sep 03, 2014 | Computers & Internet

2 Answers

Looking for a training contract from a firm that does family law?

For a person who wants to become a family lawyer primarily, you should be looking to get into law firms dealing with family law since that would be the most suitable for you. You should carry out an online search and take a look at the Law Society , the Law society is the one that regulates solicitors and it breaks down all the functions and braches that they can specialize in. There are too many places to list. You need to go through the training contract and pupilage handbook (it tells you what areas of law everywhere do) or look on the law careers website for a list of places that do training contract
Berkson Globe

Feb 02, 2013 | SonicWALL Software and Firmware Updates...

1 Answer

I dont know the product key of my microsoft office 2010. please help me

Hello cabacangrowe,
The process of getting your product key completely depends on how it was purchased, I've provided a link to Microsofts support page for recovering your key.;en;1844&showpage=4
Good luck hope this was helpful

Aug 14, 2011 | Microsoft Office 2010

1 Answer

I cracked my install cd and can not load on my new I do not like the other versions or print shop I need my deluxe 21 version

Hi,I looked into this for you and listed below you'll find all you need to get a replacement disk,hope I've helped......

If the 90-day warranty has passed and you wish to receive a replacement, please provide the following mandatory items
1. A personal check or money order for $10.95(USD) per disc requested.
2. The disk containing the defect.
3. A letter or card with your full name and return mailing address
4. A reason for the replacement request
Please send these items to the following address. We recommend you send your return via a traceable method such as Priority Mail®, UPS™ or FedEx® as Encore is not responsible for undelivered or lost packages. Please note that Encore is not responsible for the shipping cost to return the product.
Encore Software Inc.
999 N. Sepulveda Blvd
Suite 700
El Segundo, CA 90245
ATTN: Disc Replacement
From the day it arrives it will take 4-6 weeks for you to receive the replacement. If we do not have the product in stock, your check or money order (if submitted) will be returned.

Good luck....

Jun 13, 2011 | Broderbund Print Shop® 21 Pro Publisher...

1 Answer

What is 0.3000003 in words

Hello von.... The anser is three hundred thousand and three millionths. I am sorry that i did not see your question sooner. I hope this answer still helps you. Joe

Thanks for choosing Fixya!

Jul 27, 2010 | Crystal Decisions Crystal Reports Server...

1 Answer

Steps to figure out formulas in excel

Hello this is Baris,
If you forget about the numbers and start naming your cells you can figure out your own formulas... Example :)

You buy apples, and you pay $2 per piece

in this case you have 2 numbers to find out how much you will pay.

price per apple

you have 3 apples you pay 6 dollars very simple right. 2 times 3.

Same thing in excel but this time you will just say price times quantity and excel will do the calculation for you.

Lets name your cells
Type in A1 Price
Type in B1 Quantity
Type in C1 Cost

Now, Column C is your calculation area.
Type in A2 2 (price for apples)
Type in B2 3 (quantity of apples)
Type in C2 =A2*C2 (price times quantity)

Now on, you don't have to calculate anything. You can change you price and quantity, cost will change by itself. Because the value in that cell is now related to other values in A2 and B2. I hope this gives you a starting point.

Sep 30, 2009 | Microsoft Excel for PC

1 Answer

I wont to connect my mobile sigma fxd t33i to a pc but it doesnot connected

yes friend i ve the same prob , i think it needs drivers which r not included with the product. we need to search em , lets hope to get em...............

Feb 01, 2009 | Handmark Software MobileLists (950142) for...

1 Answer

Excel formula.....

Let's start with the 1st equation. I assume you want to be able to recalculate by changing the number of pages.

Put 65 in cell a1.
360 in b1
In C1, put the formula =a1/b1 that's your book thickness
In D1, put .02 for the cover
In E1, put the formula =C1+D1

Now you can change A1, B1,or D1 and the Total thickness gets recalculated automatically. Be careful not to type numbers into C1 or E1, or you lose the formula.

The same for the other equations - a cell for each number ("variable") and another cell for calculations.

Once you've verified the results, then you can get fancy and add titles above each field to make it easy to remember what goes where.

You may need to change the cell format to control the number of decimal places, or thousands commas. Right click on a cell and select format to see the choices you have.

Keep a backup copy of the spreadsheet in case someone (not you, of course) makes a mistake and overwrites the formula cells. You can also look into "protecting" cells to keep them from being changed.

Hope that helps.

Jul 14, 2008 | Computers & Internet

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

91 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18343 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides