Question about Microsoft Office Standard for PC

1 Answer

Locating provinces per area

HELLO,

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:

PROVINCE TOWNS
Pangasinan CENTRAL---------------- Bayambang
Dagupan
San Carlos
Pangasinan EAST-----------------------Binalonan
Rosales/ Carmen
Tayug
Urdaneta
Pangasinan WEST-----------------------Alaminos
Lingayen

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!!!


vincent

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

4 Answers

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


http://entouragetopst.com/how-to-convert-entourage-archive-rge-files-to-pst-file-outlook-windows/

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 | Business & Productivity Software

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.
http://support.microsoft.com/common/survey.aspx?scid=sw;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 computer...help 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
quantity

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 | Business & Productivity Software

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 Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...