RE: MS Office - Excel Questions
- From: "Ken Perry" <whistler@xxxxxxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Wed, 9 Jul 2008 17:21:34 -0700
It is both possible and the right list I don't have time to answer it in
full and if someone already has great if not what you need to do is write
some VBA functions. If you haven't wrote any Visual basic for application
functions in Excel you might want to search out some tutorials on it, it
would help you in what your doing greatly.
When I get time I can try to respond but that might not be for a week.
Ken
-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of
james.homme@xxxxxxxxxxxx
Sent: Wednesday, July 09, 2008 10:48 AM
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
//www.freelists.org/list/programmingblind
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
