|
|
YTD with conditions by
MrRJ
Hello,
I produced a formula that I need to have expanded.
=SUM('2010 Actuals'!E2:INDEX('2010 Actuals'!E2:Q2,MATCH(Sheet1!C5,'2010
Actuals'!E1:Q1,0)))
I...
|
May 12th, 2010 02:21 PM
by MrRJ
|
2 |
150 |
|
|
|
|
3 |
128 |
|
|
|
|
3 |
118 |
|
|
|
|
14 |
260 |
|
|
|
|
1 |
108 |
|
|
Receive data in column with pull down by
TooN
Hello,
I have a question regarding a pull down. I have two worksheets. In the fist
worksheet i have a pull down. In the second worksheet i have about 30...
|
|
2 |
122 |
|
|
Nesting IF Statement in excel 2007 by
Mezani
I am trying to do an if statement on a second sheet, there are three cells
that have the same drop down list in it. I tried this bu am getting an...
|
May 12th, 2010 11:08 AM
by Brad
|
2 |
157 |
|
|
Remove Text From AlphaNumeric by
Bam
Hi All,
I have a colmun of Codes, of varying lengths that contains Letters at the
end of each Code.
The letters range from 1 single letter up to a word,...
( 1 2)
|
|
11 |
215 |
|
|
VLOOKUP use column name not number by
kathy
Is there a way to use VLOOKUP to search for a column name and return the
value in that column, rather search for a column number.
--
Thank you, Kathy
|
|
7 |
187 |
|
|
Copy If rows to another worksheet by
Georgeb123
I need an Excel 2003 formula that looks at a column and copies each row that
contains a variable ("A") to another spreadsheet.
|
|
1 |
109 |
|
|
|
|
3 |
148 |
|
|
Index and Match by
winnie123
Hello All,
This is on Excel 2007
I would like to see if the array formula below can be changed to check for
another criteria.
Want this currently does is...
|
|
3 |
151 |
|
|
vlookup across multiple pages by
Mazkot
I'm trying to use vlookup to give me a summary of some number throughout a
workbook. It has to sum across about 25 worksheets. not all worksheets have
the...
|
May 11th, 2010 08:56 PM
by Mazkot
|
2 |
179 |
|
|
Data Validation by
Lost Cluster
I’m doing data validation on a group of cells. At the moment all the names
of the employees appear on the drop down list for those cells, but what I
need...
|
May 11th, 2010 08:42 PM
by zvkmpw
|
4 |
137 |
|
|
Average range of discontinuous cells by
Nadine
I have a block of columns (P-CT) that I need to average but only every 4th
one.
Example: I need to average P, T, X, AB, AF, AJ, AN, AR, AV, AZ, BD, BH, BL,...
|
May 11th, 2010 07:14 PM
by Nadine
|
1 |
110 |
|
|
Countif help needed by
Jessica Krall
I am trying to use a countif statement for column A to count the number of
times a District is "CAR" PLUS those CAR listings where column N (DAYS) is
499. ...
|
|
6 |
158 |
|
|
|
|
4 |
146 |
|
|
Forecasting by
Abby
I'm attempting to forecast the amount of money spent on the purchase of
company cars for the remaining of the fiscal year. (Column 1: Costs of cars
and...
|
May 11th, 2010 06:06 PM
by Abby
|
1 |
97 |
|
|
Auto fill Cells with text by
Robzz
I am creating a Game scoresheet and would like to know if I can use a drop
down menu in one cell and automatically fill the below cells with players of
the...
|
May 11th, 2010 05:36 PM
by Paul C
|
2 |
109 |
|
|
|
|
3 |
139 |