Previous in Forum: Windows XP Admin Password - Extended?   Next in Forum: Best Alternatives to Vista: Windows XP Pro or Version 7?
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
3 comments
Rate Comments: Nested
artist
Active Contributor

Join Date: Mar 2008
Location: UAE
Posts: 10

Microsoft Excel Formula

09/29/2009 3:31 PM

Hi all,

USAFranceAlgeriaUAE
USA400500600
France400800900
Algeria5008001200
UAE6009001200

the table above shows distances between many countries. I am looking for the formula which edit automaticly the distance between two countries if I enter the name of two countries.

I will be grateful if someone can give help.

Regards,

__________________
 When you want to do something good, do it, don't hesitate maybe it's your last time to do some thing!
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
Mikerho
Guru
Hobbies - Musician - Engineering Fields - Chemical Engineering - New Member Engineering Fields - Control Engineering - New Member Engineering Fields - Instrumentation Engineering - New Member

Join Date: Jan 2007
Location: Moses Lake, WA, USA, Thulcandra - The Silent Planet (C.S. Lewis)
Posts: 4216
Good Answers: 194
#1

Re: Microsoft Excel Formula

09/29/2009 4:39 PM

When is this homework due?

__________________
 "Reason is not automatic. Those who deny it cannot be conquered by it. Do not count on them. Leave them alone." - Ayn Rand
Register to Reply
nick name
Guru

Join Date: Mar 2007
Location: City of Light
Posts: 3943
Good Answers: 183
#2

Re: Microsoft Excel Formula

09/30/2009 1:41 AM

It is a macro you have to write. You have access to VBa and there are lot of books on the language and how to use it. You can also try to find via google the macro and use it.
Register to Reply
design-engineer
Power-User
United Kingdom - Member - New Member Engineering Fields - Energy Engineering - New Member Engineering Fields - Piping Design Engineering - New Member Fans of Old Computers - Commodore 64 - New Member Technical Fields - Technical Writing - New Member

Join Date: Jun 2007
Location: Windsor UK
Posts: 103
Good Answers: 1
#3

Re: Microsoft Excel Formula

10/02/2009 4:25 AM

Try looking up the Excel help file on the following function

VLOOKUP

I think that will provide the function you need

__________________
 Those who believe in telekinetics, raise my hand - Kurt Vonnegut
Register to Reply
Register to Reply
Have a Different Question?
3 comments
Copy to Clipboard

Users who posted comments:

design-engineer (1); Mikerho (1); nick name (1)

Previous in Forum: Windows XP Admin Password - Extended?   Next in Forum: Best Alternatives to Vista: Windows XP Pro or Version 7?

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (59 right now)
Show Members
Advertisement