|
|
|
|
3 |
346 |
|
|
|
April 21st, 2010 09:57 PM
by Mike H
|
4 |
220 |
|
|
|
|
3 |
198 |
|
|
|
|
0 |
201 |
|
|
Excel 2003 - Skip a cell by
Ed
How do I skip a blank cell? I have a column of dates (Col A) and a column of
numbers (Col C). Col C has irregular blanks. I want to copy these to another...
|
April 21st, 2010 09:21 PM
by Ed
|
5 |
271 |
|
|
counting by
pierre
hello
i have cells from A1:A3 and A6:A10 which contain text strings.
now what should be the formula if i want to count these cells ? (answer
should be...
|
|
2 |
171 |
|
|
Removing spaces from middle of cell by
TJAC
In my spreadsheet there is a column that contains number, 3 on the left,
space, 3 on the right. I want to remove that space. Rather than doing this
in...
|
|
5 |
284 |
|
|
Tables and Custom views in Excel 2007 by
Mervyn Thomas
I now find that the latest version does not allow tables and custom views to
coexist. I have loads of sheets which are driven by ODBC feeds which...
|
|
1 |
438 |
|
|
allow merging cells in protected sheet by
Doug
When I protect the sheet, the Merge & Center button is greyed out. I need to
allow users to merge and center cells in a protected sheet (these cells are
not...
|
April 21st, 2010 07:57 PM
by Doug
|
0 |
293 |
|
|
look up formula by
Jane Griffel[_2_]
I have two customers with two different list of procedures on one report.
cell A1 has a drop down list of the customers when a certain customer is
chosen How...
|
|
3 |
214 |
|
|
Formula shows as text by
EmilyE
I'm trying to write a formula into a cell and it will work in some, but in
other cells it makes the formula show in the cell as if I am just typing text.
Why...
|
April 21st, 2010 07:44 PM
by FSt1
|
1 |
199 |
|
|
|
April 21st, 2010 07:32 PM
by Don
|
1 |
207 |
|
|
Sum of two groups by
JHL
I have the following formula attempting to get some totals by aging category.
=SUMPRODUCT(--(B2:B1096=T12),--(AA2:AA1096=U11),Q2:Q1096)
T12 = a 2 digit code...
|
|
1 |
157 |
|
|
|
April 21st, 2010 07:19 PM
by Don
|
1 |
177 |
|
|
|
April 21st, 2010 07:11 PM
by Don
|
2 |
196 |
|
|
Lookup formula by
Michael
Hi, I have a lookup that is looking at 2 different worksheet and the formula
is
=IF(ISERROR(IF($D1="ruth baybutt",HLOOKUP(A$3,ruth...
|
|
2 |
212 |
|
|
|
April 21st, 2010 07:01 PM
by Don
|
2 |
238 |
|
|
|
|
2 |
224 |
|
|
Lookup Formula by
EmilyE
I'm not sure if this would be a look up formula, but is there a formula where
I can type in a number in one cell and in the cell next to it, it will pop up
a...
|
|
2 |
176 |
|
|
Pie of Pie by
Jeff
Can anyone walk me through how to build a "pie of pie" chart? That is, I
need a secondary pie chart to "explode" a slice of the main pie chart.
Excel's...
|
April 21st, 2010 06:29 PM
by Billns
|
5 |
281 |