filter with condition s
Wed, 24 Sep 2008 19:46:17 +0300
Sum gives the total of all numerical values even when autofilter is on
Subtotal gives the correct sum for the filtered rows
How can I have a list of all functions that works with autofilter is on.
...
|
AverageIf Help
Wed, 24 Sep 2008 09:39:39 -0700
I tried the following forumla (and many, many others) but it obviously
doesn't work.
=averageif(c15:c2500=b2,x15:x2500="e",n15:n2500)
I type a name into B2 that corresponds with some of the names in
Column C. When those names match an "e" in column X I then want to
average the corresponding values in colum ...
|
filter
Wed, 24 Sep 2008 19:32:56 +0300
Sum gives the total of all numerical values even when autofilter is on
Subtotal gives the correct sum for the filtered rows
How can I have a list of all functions that works with autofilter is on.
...
|
list box in excel as option for msquery
Wed, 24 Sep 2008 08:46:32 -0700 (PDT)
I have a set of data that looks like this
STATE CITY
OR Portland
OR Beaverton
WA Seattle
WA Olympia
WA Spokane
CA Los Angeles
CA San Diego
CA San Jose
What I would like to be able to do is have 3 list boxes, the first one ...
|
Macro/Control object to insert a row
Wed, 24 Sep 2008 07:53:23 -0700 (PDT)
I'm adding a macro to a spreadsheet that will insert a row, then copy
the data from the original row. that part works fine, but I can't get
the option button to work in any row but the first ...
|
Problem with diagram Excel 2007
Wed, 24 Sep 2008 16:44:19 +0200
Hi,
We run Windows XP Sp3 computers with Office Suite Pro 2007 installed. In
Excel 2007 we encounters the following issue/problem.
- Reversing only the vertical axis in a diagram
In an excel-document I have data that generates a diagram in another
document.
These data have to be put in with the newest ...
|
Cell Protecton and Conditional Formating
Wed, 24 Sep 2008 09:16:28 -0500
Windows XP, Excel 2003
Cell A14 is a Dropdown containing: blank, cash, check and credit card.
Based on conditional formatting formula I have been able to change both the
foreground and background color of other cells. I would like to be able to
lock and unlock cells based on the same conditional formula. ...
|
|
|
How to remove evidence of a macro?
Wed, 24 Sep 2008 09:56:26 -0400
Someone at work once showed me how to do this but I flat out don't remember
what to do (and he's not here now).
Excel97 if that matters.
Using Tools/Macros/Record New... I recorded a keyboard macro to do the same
thing to a number of sheets.
It worked perfectly.
I then went back to Macros... and deleted it a ...
|
date format
Wed, 24 Sep 2008 03:40:01 -0700
Hi all,
I have a spreadsheet containing lots of pivot tables. The source data
contains date formulas in the following ways:
=IF(FR5="","",TEXT(FR5,"yyyy-mm")) this returns dates like----- 2007-11
=IF(GM5="","",TEXT(GM5,"mmm-yy")) this returns dates like------- Nov-07
As a result, when I try to sort my ...
|
Microsoft Migrates From Servers to Supercomputers
Wed, 24 Sep 2008 03:21:05 -0700 (PDT)
Once relegated to the realm of national laboratories, supercomputers
have started to move downstream. These days, any business with $25,000
to $100,000 to spare can buy a computing system capable of cranking
through very difficult tasks. And, in fact, more businesses than ever
have started to buy exactly these t ...
|
