|
|
Creating column by
AAA1986
I would like to create a column that automatically adds one for each row.
Ex. 2001, 2002, 2003, 2004
|
|
1 |
123 |
|
|
|
Creating Average IF by
AAA1986
I need the following function:
I want the average of I3:I6 only for records where 03:06 = 18.
Please help! Thanks in advance.
|
December 9th, 2009 02:47 PM
by AAA1986 
|
6 |
100 |
|
|
|
Difficult function question for columns by
AAA1986
I would like the create a column that performs the following function:
If it is of any importance, in the above example B10:12 have a
=SUMIF/COUNTIF...
|
December 22nd, 2009 02:38 PM
by AAA1986
|
3 |
134 |
|
|
|
Change "FALSE" to "NO DATA" by
AAA1986
Right now I have the following function in a cell column:
=IF(P18="PMR",E$26)
But when the referenced cell does not equal "PMR" it turns up as "FALSE".
Can...
|
|
4 |
130 |
|
|
|
COUNTIF? by
AAA1986
Each entry in my database has a category listed in column A. I would like to
create a column that produces the n for each entry's category.
For example, if...
|
|
6 |
105 |
|
|
|
Column Average Given 2 Criteria by
AAA1986
I want to get the average for a certain column, given 2 different criteria.
Right now I'm using this formula for one...
|
|
4 |
125 |
|
|
|
Copy data ONLY from a function cell by
AAA1986
I want to copy and paste the data derived a function in a cell. If I copy the
cell, it will carry the function with it. Is there a way I can copy only the...
|
December 9th, 2009 04:32 PM
by AAA1986
|
4 |
106 |
|
|
|
|
March 16th, 2006 03:18 PM
by colin_e
|
1 |
88 |
|
|
|
|
March 28th, 2007 11:32 AM
by Mike
|
1 |
41 |
|
|
|
|
|
1 |
71 |
|
|
max value by
aaaist
hi
i need help lol
for exemple:
A B
1 joao 5.5
2 fred 8.6
3 Jose 7.8
i want the excel calc the maximum value and return me the name...
( 1 2)
|
October 27th, 2005 10:17 PM
by DOR
|
15 |
137 |
|
|
|
|
January 20th, 2006 12:02 AM
by Pete
|
4 |
121 |
|
|
|
quantitative strategy question by
aaamy98
Hi everyone,
I'm taking this quantitative reasoning course and I have a professor
who isn't the best at answering questions so I'm turning to you guys.
I...
|
April 20th, 2004 06:07 AM
by aaamy98
|
0 |
242 |
|
|
|
need a formula by
Aaargh
I'm trying to set up a formula that will check the value of a cell, then
based on the value of that cell, will insert another value....i.e.
If C2 =1, then G2...
|
|
8 |
84 |
|
|
|
Pivot range update on mulitple tables by
aablank
I am using the same range for a number of pivot tables. If
I add to the data, is there a way to update all of the
tables at once? Right now I need to update...
|
September 15th, 2003 04:12 PM
by aablank
|
0 |
1,174 |
|
|
|
Pivot table update by
aablank
I have a number of pivot tables based on the same data
worksheet. Right now when I add more data, I have to go
to each table and update the range manually. ...
|
September 16th, 2003 06:46 PM
by aablank
|
3 |
471 |
|
|
|
Can't change Pivot Table data source by
AABob
Excel 2007. My pivot table is currently pointing to an MS Access
database. I want to change it to point to a worksheet within the
same workbook. When I go...
|
|
1 |
62 |
|
|
|
Make cells flash. by
aacstv
I need to know the step-by-step process on how to make cells...
|
|
1 |
144 |
|
|
|
|
July 23rd, 2008 11:12 AM
by Pete_UK
|
1 |
91 |
|
|
|
|
|
5 |
113 |
