Welcome to the Australian Ford Forums forum.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and inserts advertising. By joining our free community you will have access to post topics, communicate privately with other members, respond to polls, upload content and access many other special features without post based advertising banners. Registration is simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Please Note: All new registrations go through a manual approval queue to keep spammers out. This is checked twice each day so there will be a delay before your registration is activated.

Go Back   Australian Ford Forums > General Topics > Non Ford Related Community Forums > The Bar

The Bar For non Automotive Related Chat

Reply
 
Thread Tools Display Modes
Old 31-05-2011, 02:10 PM   #31
XR6_661
Cane Farmer
 
XR6_661's Avatar
 
Join Date: Jun 2006
Location: Tom Price, WA
Posts: 4,056
Default Re: Excel formula help?

Quote:
Originally Posted by b2tf
You're a sick twisted individual.

I've re-hashed the template to get around the cell multiplication issue.
Love a good spreadsheet.
__________________

1994 ED XR6T - Cobalt Blue.



2009 FG XR6 - Black.


Quote:
Originally Posted by Tex
I couldn't give a crap how many are in their family, what gay passtimes they paticipate in, or whether they have a cat, dog or a freaken fish.

Keep your stinking family to yourself god damn it.
XR6_661 is offline   Reply With Quote Multi-Quote with this Post
Old 21-02-2013, 08:19 PM   #32
paulb351
Guest
 
Join Date: Sep 2011
Posts: 418
Default

Quote:
Originally Posted by gcg2503 View Post
mmm the joys of excel - vlookups, whatif statements, pivot tables....

Access for the win!
For bonus points try replacing vlookups with array formulas. Much faster calc times when dealing with large data sets

Then try dynamic range names to spin the brain matter
paulb351 is offline   Reply With Quote Multi-Quote with this Post
This user likes this post:
Reply


Forum Jump


All times are GMT +11. The time now is 11:13 AM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Other than what is legally copyrighted by the respective owners, this site is copyright www.fordforums.com.au
Positive SSL