LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default What-If with data tables?

I've been learning What-If Analysis with data tables. Data tables strike me
as an overcomplicated and contrived method of doing something that could be
done much more easily and naturally without this 'feature'.

In both 1 or 2-variable tables you wind up with a value or values (where
your formula(s) are entered) that seem out-of-place or spurious, formatting
seems less than desirable and requires thought, and you've got to go
through--and remember each time--certain steps to get it all right. (see:
http://office.microsoft.com/en-us/ex...726561033.aspx )

Why not just enter your non-calculated values somewhere, then Auto Fill your
variable(s) and formula(s) however you like, wherever you want, and without
having to remember any wacky procedure?

What am I missing?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing Data Tables formed from importing data from Access Andrea Jones Excel Discussion (Misc queries) 0 April 10th 08 12:01 PM
PLEASE ANYONE ... DATA IMPORT EXTERNAL DATA - WEB TABLES Sacs Excel Discussion (Misc queries) 2 January 18th 08 12:51 AM
DATA > TABLE -- 2 variable data tables? efarhat Excel Worksheet Functions 1 August 24th 05 10:35 PM
DATA > TABLE -- 2 variable data tables? efarhat Excel Discussion (Misc queries) 0 August 24th 05 07:29 PM
How to cause a pivot tables to not summarize data - just report the data Greybeard Excel Discussion (Misc queries) 0 July 27th 05 10:21 PM


All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"