CR4 - Thread: Microsoft Excel Formula

Home | Software & Programming | Software & Programming | Microsoft Excel Formula

Previous in Forum: Windows XP Admin Password - Extended?

Next in Forum: Best Alternatives to Vista: Windows XP Pro or Version 7?

3 comments

Rate this

Comments: Nested

artist

Active Contributor

Join Date: Mar 2008

Location: UAE

Posts: 10

Microsoft Excel Formula

09/29/2009 3:31 PM

Hi all,

USA	France	Algeria	UAE
USA	400	500	600
France	400	800	900
Algeria	500	800	1200
UAE	600	900	1200

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!

Send to a friend Digg this Add to del.icio.us

Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Join CR4, The Engineer's Place for News and Discussion!

Mikerho Guru Join Date: Jan 2007 Location: Akron, OH, USA, The Silent Planet Posts: 949 Good Answers: 29	#1 Re: Microsoft Excel Formula 09/29/2009 4:39 PM
	When is this homework due? __________________ "Try not. Do or do not, there is no 'try'." Yoda

nick name Guru Join Date: Mar 2007 Location: City of Light Posts: 1736 Good Answers: 40	#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.

design-engineer Commentator Join Date: Jun 2007 Location: Windsor UK Posts: 84	#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

3 comments

Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Join CR4, The Engineer's Place for News and Discussion!

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?

You might be interested in: Publishing Software, Power Transformers, Multi-screen Display Controllers

"In any contest between power and patience, bet on patience." -- W.B. Prescott

All times are displayed in US/Eastern (EST) (Register to change time zone)

©2005-2009 GlobalSpec. All rights reserved.
GlobalSpec, the GlobalSpec logo, SpecSearch, The Engineering Search Engine
and The Engineering Web are registered trademarks of GlobalSpec, Inc.
CR4 and Conference Room 4 are registered trademarks of GlobalSpec, Inc.
No portion of this site may be copied, retransmitted, reposted, duplicated or
otherwise used without the express written permission of GlobalSpec Inc.
350 Jordan Rd, Troy, NY, 12180

	Got Something to Say?

	Search this Forum
	Software & Programming:

	Search all of CR4

CR4 Sections

	Automotive
	BioMech & BioMed
	Chemical & Material Science
	Civil Engineering
	Communications & Electronics
	Education
	Electrical Engineering
	Engineering Careers
	General
	Instrumentation
	Manufacturing
	Mechanical Engineering
	New Technologies & Research
	Software & Programming
	Sustainable Engineering