Averageif?
Thu, 11 Mar 2010 15:35:34 -0800
1 -20
1.6 -20
2.4 pass
3 35
1.5 14
2.7 7
How do I average the numbers in column A if the numbers in column B
are greater than 0? There is some text in column B.
...
|
Dropdown list
Thu, 11 Mar 2010 12:38:14 -0800 (PST)
Using XL 2003, i have a workbook that has hundreds of cells to enter
data in. i want the user to be able to select from a dropdown list.
The data that would be in the list would look something like this..
1 15 minutes
2 23 minutes
3 33 minutes
4 44 minutes
etc, etc.
What i would like to do is to have t ...
|
Show data depending on value
Thu, 11 Mar 2010 11:02:54 -0800 (PST)
I want to automatically populate the "Rates" from another worksheet. I
tried the formula
=IF(ROW(G50)<=COUNTIF('Working Data'!K:K,F50),INDEX('Working Data'!
L:L,SMALL(IF('Working Data'!$K$6:$K$207=F50,ROW($A$6:$A
$207)),ROW(G50))),"")
but, the return value was blank. The value should have been .1465
I have ...
|
Excel 2010 Slicer Connection / Pivot Table Problem
Thu, 11 Mar 2010 09:53:08 -0800 (PST)
Working in Excel 2010 beta. I have two pivot tables created from
different SSAS cubes. I have PowerPivot add in installed, but not
using it for this project. The two pivot tables both share several
similar dimensions. When I try to connect a given slicer to both pivot
tables, the 2nd pivot table is not availabl ...
|
add numbers in same cell with Auto Sum
Thu, 11 Mar 2010 09:21:01 -0800
I am using XP 2003 Excel and have a spreadsheet with a large column of cells
that have multiple numbers in each cell and the numbers are separated by a
slash or divide line, ie: '170/13/3. These #'s are actually 170+13+3. Is
there a way to do an Auto Sum on this column without changing the slash lines
to ...
|
Showing Cell Outline
Thu, 11 Mar 2010 15:10:39 -0000
Can anyone explain to a dummy how to keep the grid lines of a worksheet
visible after making the background coloured? I have been to Advanced
Properties and set 'show grid', but it disappears when I add a colour.
Many thanks in advance for any help you can give.
...
|
Formula to extract first listed item
Thu, 11 Mar 2010 03:34:04 -0800 (PST)
Hi all
If I have in Column A a list of countries such as:
Australia
USA/Australia
USA/UK/Germany
USA
I want in Column B a list of just the first listed country. I have a
solution which seems pretty clunky and am wondering how to improve on
it. My formula looks like this:
=IF(A1="", "", IF(ISERROR( ...
|
|
|
Using english and non-English Excel commands simultaneously in a
non-English installation
Thu, 11 Mar 2010 02:29:37 -0800 (PST)
Hi community,
I like this forum very much - I got many valuable insights from it. In
the past I had an English Excel installation at the office available,
recently my employer moved to the German version and deinstalled the
english one.
Now, when i use a english command like =VLOOKUP(A1,'Sheet 2'!
A1:H200,8,FA ...
|
conditional formatting & formula
Wed, 10 Mar 2010 19:41:44 -0000
Hello
I'm working on a spreadsheet and would like to highlight the highest value
across.
i.e.
Name 1 2 3 4 5 6
7
Mary 1% 2% 2% 25% 45% 15% 10%
These are the student's probabilities to achieve grades 1 t ...
|
Count Tick Marks from Code given by Jacob Skaria
Wed, 10 Mar 2010 11:19:46 -0800
Dave,
For whatever reason (code maybe?) all it returns me is "FALSE" in the cell where I type those formulas. It does not seem to be acknowledging those "e"s or "r"s.
Dave Peterson wrote:
=countif(a:a,"e")will count the number of cells with e=countif(a:a,"r")will
10-Mar-10
=countif(a:a,"e")
will co ...
|
