Re: MS Office - Excel Questions

Hi,
Sounds like I need to explore pivot tables then. I've never used them. I'll
check that out.

Thanks.

Jim

James D Homme, Usability Engineering, Highmark Inc.,
james.homme@xxxxxxxxxxxx, 412-544-1810

"it is only possible to live happily ever after on a day-to-day basis." --
Margaret Bonnano

Highmark internal only: For usability and accessibility:
http://highwire.highmark.com/sites/iwov/hwt093/


                                                                           
             "Dorene Cornwell"                                             
             <dorenefc@xxxxxxx                                             
             om>                                                        To 
             Sent by:                  programmingblind@xxxxxxxxxxxxx      
             programmingblind-                                          cc 
             bounce@freelists.                                             
             org                                                   Subject 
                                       Re: MS Office - Excel Questions     
                                                                           
             07/13/2008 09:31                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             programmingblind@                                             
               freelists.org                                               
                                                                           
                                                                           




Jim

What version of Excel are you using?

Maybe I am missing something, but why wouldn't you use a pivot table
especially if you also want time interval drill down / rollups? With a
pivot table you have the option of filtering for specific values.

Or are you wanting to accumulate valures for each time interval and then do
something with them?

Check out the syntax for three-dimensioanl references and also the Vlookup
function.

Perhaps this will help.

Dorene Cornwell
Seattle WA

On Fri, Jul 11, 2008 at 5:56 PM, Chip Orange <Corange@xxxxxxxxxxxxxxx>
wrote:
  Sorry, I'm not on this list often, but I have man books on Excel and VBA
  programming.  Just email me off list and tell me the version of Excel
  you're using, and I'll let you know what I've got (that is, if you're
  still looking for books).

  Chip





  ------------------------------

  Chip Orange
  Database Administrator
  Florida Public Service Commission

  Chip.Orange@xxxxxxxxxxxxxxx
  (850) 413-6314

   (Any opinions expressed are solely those of the author and do not
  necessarily reflect those of the Florida Public Service Commission.)


  > -----Original Message-----
  > From: programmingblind-bounce@xxxxxxxxxxxxx
  > [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of
  > james.homme@xxxxxxxxxxxx
  > Sent: Wednesday, July 09, 2008 1:48 PM
  > To: programmingblind@xxxxxxxxxxxxx
  > Subject: MS Office - Excel Questions
  >
  >
  > Hi,
  > Please forgive me if this is off topic.
  >
  > I'd like to get an idea if array formulas will help me with a
  > problem in
  > Excel. First, I need to understand how they work. Secondly,
  > here is the
  > problem. In a work sheet, I have a column of data that I want
  > to use for
  > categories. On another sheet, I formatted a column so that it
  > contains a
  > drop down list that picks from the column in the first sheet.
  > Here's the
  > issue. I want to add to a total that corresponds to whatever
  > category I
  > happen to pick. For example, if the category in a cell is
  > baseball tickets,
  > I want to add to that total. If the category is clothes, I
  > want to add to
  > that one. I would very much like to avoid summing categories
  > even if they
  > have zero values. By that, I mean that I don't want to have
  > to have a sheet
  > that has a row for every single category. I just want to add
  > to a category
  > total if I pick it. Besides all of that, I want to roll up
  > everything into
  > daily, weekly, and monthly totals only for the categories I
  > use. I don't
  > even know if all of this is possible. If this is the wrong
  > list to talk
  > about this on, where can I take the question?
  >
  > Thanks.
  >
  > Jim
  >
  > James D Homme, Usability Engineering, Highmark Inc.,
  > james.homme@xxxxxxxxxxxx, 412-544-1810
  >
  > "it is only possible to live happily ever after on a
  > day-to-day basis." --
  > Margaret Bonnano
  >
  > Highmark internal only: For usability and accessibility:
  > http://highwire.highmark.com/sites/iwov/hwt093/
  >
  > __________
  > View the list's information and change your settings at
  > http://www.freelists.org/list/programmingblind
  >
  >
  __________
  View the list's information and change your settings at
  http://www.freelists.org/list/programmingblind



__________
View the list's information and change your settings at 
http://www.freelists.org/list/programmingblind

Other related posts: