|
|
|
October 27th, 2009 06:28 PM
by MJ
|
2 |
227 |
|
|
|
|
1 |
213 |
|
|
Averaging values by
RUSH2CROCHET
Hello everyone:
Hoping someone can assist...
I have a spreadsheet which reflects copier meter clicks as reported from
1'08 through current day. My...
|
|
1 |
201 |
|
|
|
|
2 |
253 |
|
|
Retrieve first 3 words in a cell by
KrispyData
I have an address field and I would like to create a formula to retrieve the
first 3 words in the address. How can I do this?
example:
1245 main street...
|
|
6 |
151 |
|
|
Calculate workdays in a month. by
YY san.[_2_]
Hi,
I have in A1, 2009 and A2~A13, numbers 1 ~ 12 representing Jan ~ Dec. This
is format as numbers, not date format. How can I use NETWORKDAYS in B2 to...
|
|
4 |
182 |
|
|
"0" Values on Pivot Chart? by
Ken
Excel2003 ... I have a Pivot Table returning some "empty" cells in the Data
Section. This is ok ... However, when I create my Pivot Chart (Bar) ...
these...
|
October 27th, 2009 05:58 PM
by Ken
|
0 |
196 |
|
|
|
|
0 |
131 |
|
|
If then and more by
JJP
Good Morning Everyone,
I am in the process of creating an excel spread sheet that will be used to
track student tardiness. To this point I am using the...
|
|
1 |
145 |
|
|
|
October 27th, 2009 05:44 PM
by XX23
|
18 |
486 |
|
|
|
|
0 |
142 |
|
|
Can I use vlookup to do this? by
Coeus
I have a sheet like below:
aaa 1
bbb 2
bbb 3
ccc 4
ddd 5
ddd 6
ddd 7
Now I want to reorganize the table like below:
aaa 1
|
|
4 |
315 |
|
|
|
|
2 |
230 |
|
|
|
|
1 |
126 |
|
|
|
October 27th, 2009 05:06 PM
by Bob I
|
1 |
243 |
|
|
formulas, if/then by
nan4ca
Is there a way to set up a worksheet so that if a condition is met in a cell
then a formula will be performed in another?
Ex.: If, in A1, the data is equal...
|
|
1 |
118 |
|
|
|
October 27th, 2009 04:46 PM
by smck
|
2 |
156 |
|
|
Conditional List dropdowns? by
GD
Hi, i'm looking to add a condition to certain list drop-down options based
upon the selection in a prior dropdown, is this possible?
For example dropdown A,...
|
|
1 |
139 |
|
|
If........then...... by
nan4ca
Is it possible to create a formula that if a condition is met in a cell, then
go to another cell and perform formula in that cell?
For Ex.: If the data in...
|
|
2 |
210 |
|
|
|
October 27th, 2009 04:41 PM
by Bob I
|
7 |
271 |