|
|
|
|
6 |
142 |
|
|
Complex 2 table formula by
JD
Here are my two tables:
Table 1
Column 1 Col 2 Col 3 Col 4 Col 5
Col 6 Col 7
Row 1 Slope Bands...
|
December 30th, 2009 12:35 AM
by JD
|
5 |
111 |
|
|
Countif Formula by
JKVA
I imagine this is a simple question, but I would like to do something like
the formula below, but I would like to do it for a range within 15 minutes
(+15 or...
|
December 29th, 2009 10:52 PM
by T. Valko
|
3 |
105 |
|
|
Forms--Vista--2007 Excel by
Lost in Excel
Hello, I am working on an Excel Worksheet, using it as a survey, and need to
accomplish 3 tasks.
1.) I want the user to check, or place an "X" only one of...
|
|
2 |
118 |
|
|
Need Help by
Cindy
I have a workbook containing the following tabs (sheets)
Control
upload
audit
lookup
I am trying to figure out a formula that will do the following
In the...
|
December 29th, 2009 09:54 PM
by Cindy
|
4 |
94 |
|
|
|
|
3 |
124 |
|
|
Separating data by
GeorgeHutch
I am currently sorting through endless data wich i only need a small part of
it.
the data looks like this below but 100 time as long and in a text file. ...
|
December 29th, 2009 09:06 PM
by Stefi
|
6 |
83 |
|
|
|
December 29th, 2009 08:38 PM
by Max
|
3 |
102 |
|
|
Auto calculating not working by
Marcia
For the first time in 20 years of using Excel, I am finding that auto
calculation is not taking place whenever I add new entries to a range of
cells included...
|
|
4 |
94 |
|
|
Autosum returns zero balance - why? by
MarcyC
Excel 2003
I've been adding both contiguous and non-contiguous numbers using the
autosum function OR =c2+c5+c9 OR =SUM(c2,c5,c9) OR =SUM(a1:a50). In a few...
|
December 29th, 2009 06:44 PM
by MarcyC
|
0 |
90 |
|
|
once only pop up by
Phil
Hi there,
I've created a message that comes up upon opening a worksheet template i've
created that reminds the user to resave this workbook first before...
|
|
3 |
126 |
|
|
|
December 29th, 2009 05:17 PM
by Pete_UK
|
2 |
96 |
|
|
Countifs in 2003 = _xlfn. ?? by
Steve
I created some countifs in 2007, saved it down to 2003. When opened in 2003,
in front of the countifs is: =_xlfn.COUNTIFS
It showed correctly in 2003,...
( 1 2)
|
December 29th, 2009 04:47 PM
by T. Valko
|
12 |
170 |
|
|
Product Formula by
Alan
Hi,
I have a column of quarterly returns which I wish to calculate longer term
returns from. My problem is that the list will continue to expand over time...
|
|
1 |
133 |
|
|
formula for excel sheet. by
BVG
Hi,
I want to use a formula in excel as below described.
i want a formula value in Cell A2.b In Cell A1 is value say if it is $ 500
or above then the A2...
|
|
5 |
89 |
|
|
-/+ forumla by
gma
ok....i have a need for a forumla that will increase and decrease as the
value in another cell goes up or down. i.e.
A1 set number of 95
B1 number is 96
C1...
|
December 29th, 2009 02:54 PM
by gma
|
4 |
81 |
|
|
Error with Copy function by
diepvic
Hi,
I'm trying to copy data from workbook A to workbook B. However, whenever I
select workbook B, the Paste function is blur, which means I can not paste...
|
December 29th, 2009 12:12 PM
by diepvic
|
0 |
84 |
|
|
|
December 29th, 2009 11:00 AM
by Mike H
|
1 |
199 |
|
|
S- Curve Calculation and chart by
vmohan1978
Dear All,
I have to prepare S-curve for the Project with following informarion
Project Duration : 30 Months
Project Cost : 90,000,000
Note : I tried Total Cost...
|
|
3 |
100 |
|
|
Variable Pay-rate after 5pm by
SchMattX
After 5pm employees get paid a different rate per hour.
Currently 4 entries for time "in" and "out" before and after lunch.
Need to have Excel determine...
|
|
1 |
103 |