|
|
|
|
8 |
111 |
|
|
|
|
3 |
70 |
|
|
Excel formula using non-literal values by
jbdmom
I have defined a formula that tests the value in 3 columns. If the value in
each column passes the test, the formula calculates a value for another
column. ...
|
|
3 |
89 |
|
|
stopwatch average per mile by
JBT
I'm trying to come up with the avg/mile for race times. Is there a formula or
setting that needs to be used?
|
|
2 |
68 |
|
|
VLOOKUP returning #N/A by
Michelle7890
I am using vlook up in a list of accounts that varies from week to week. How
can I make vlookup return a 0 or blank rather than the pesky N/A when a...
|
|
5 |
63 |
|
|
nesting sumif functions by
Macil
can I nest a sumif function within a sumif function? i want to sum the data
with in column c if data in coulmn a ="a" and data in column b="b" Here is
what...
|
|
5 |
92 |
|
|
|
|
3 |
71 |
|
|
Subtracting 2 hours from a time.... by
Literalgar
I am creating a spreadsheet with a tab for different time zones... to
convert from the eastern time sheet where the times are manually entered, in
the...
|
|
2 |
77 |
|
|
|
|
6 |
114 |
|
|
Must save to view formula results by
S R
I'm doing a sum on a single column of numbers =sum(d3:d50). After updating
new values to the column I now must save the worksheet to view the updated
formula...
|
|
6 |
117 |
|
|
fill handle in Excel by
Broadbrook
Where is this mythical fill handle. I have it enabled, but I can't find it.
Thanks!
|
|
4 |
75 |
|
|
#missing! by
Arne Hegefors
Hi! I have a worksheet with several tables. The tables are linked to each
other using functions such as LOOKFORROW and others. I want to calculate the...
|
|
2 |
114 |
|
|
|
October 15th, 2008 05:40 PM
by Brad
|
3 |
104 |
|
|
|
October 15th, 2008 05:35 PM
by David
|
2 |
87 |
|
|
Pivot - top 10 stocks & missing info by
Christine[_3_]
i have a lot of stocks with info like GRN date, qty, value, lead time etc.
I used pivot table to consolidate as some items has a few lines because of...
|
|
1 |
93 |
|
|
|
|
3 |
91 |
|
|
|
October 15th, 2008 05:16 PM
by LJ
|
0 |
119 |
|
|
Inserting a formula into a sentance. by
Stacey
I would like to put a formula into a sentance, the sentance is not allows the
same so I can not have it in two cells and print it the way I want it...
|
|
3 |
130 |
|
|
cell for date last updated by
houseman
I am trying to set up a cell for each row that shows when that row was last
updated... any suggestions??
thx
|
|
1 |
149 |
|
|
Shading Rows With IF Statements? by
JPS
I have a large spreadsheet and based on a status indicator in Column DW, I
need to shade the entire row one of eight colors, For example, if a cell
value in...
|
|
5 |
108 |