|
|
|
|
2 |
250 |
|
|
Calc duplicates by
backmara
Hi,
I need function to calculating duplicates, how I create this?
A1: 1
A2: 2
A3: 2
A4: 3
A5: 3
A6: 3
A7: 4
A8: 5
|
|
3 |
248 |
|
|
Pivot Charts by
GD
hi, i'm using a pivot chart to show some data in which the X Axis is a Month,
the Y Axis from 0 to 100, and then 5 series with monthly figures between
0-100...
|
November 11th, 2009 11:38 AM
by GD
|
0 |
210 |
|
|
"Dynamic" hyperlink by
Espen Rostad
I have to create a large wb with one sheet per day named actual dates. On the
front page i need a cell to put the desired sheet (by entering date) to go
to....
|
|
8 |
221 |
|
|
Pivot tables and percentages by
Ajay
Morning All
I have a pivot table formatted as below:
Company Business Unit Calibration Result Count
ABS 123 ...
|
November 11th, 2009 09:53 AM
by Ajay
|
0 |
217 |
|
|
|
|
1 |
212 |
|
|
|
November 11th, 2009 09:44 AM
by Vinod
|
0 |
241 |
|
|
New link by
flyfree
I have two identical spreadsheets and when I update the first I want the
second to be updated also. (Step-by-step please, I haven't set up a link
before)
|
November 11th, 2009 09:31 AM
by flyfree
|
3 |
219 |
|
|
Default format of cell comments by
Al
When I create a comment against a cell, it seems that the default formatting
is “Don’t move or size with cells.” This causes many problems when I hide...
|
November 11th, 2009 08:03 AM
by Al
|
4 |
253 |
|
|
|
|
1 |
215 |
|
|
|
November 11th, 2009 07:49 AM
by Bobi
|
0 |
190 |
|
|
Variable statement by
doobie
I need a fn to substitute for a variable value in a SUM fn., in other words
my problem as indicated in below table
(Hrs) 2 2 3 1
Student
...
|
November 11th, 2009 07:42 AM
by doobie
|
3 |
205 |
|
|
|
November 11th, 2009 07:34 AM
by ch
|
2 |
228 |
|
|
subtraction task by
Jamie
Excel 2003
I'm tracking weight loss.
In one column I have a list of #'s.
The top # is the beginning weight.
Each # under the beginning weight is from...
|
November 11th, 2009 05:51 AM
by Jamie
|
5 |
213 |
|
|
Additions by
Marc
Hi, I have data similar to the bottom. I want to add all the Zauri Inds,
Zyden Gentec, Zydus Wellness, Zylog Systems. How do i do that? I want to drag
a...
|
|
1 |
204 |
|
|
Named range labels in formulas by
KLUG
I created names ranges in an existing workbook. In order to get formulas to
use the named range in the formula, I hit F2 in a formula cell and ENTER as...
|
November 11th, 2009 05:09 AM
by T. Valko
|
1 |
214 |
|
|
Convert julian date by
JHL
I have a julian format of YYDDD. The formula I'm using is off a day and a
century.
Formula =date(left(a1,2),1,(mid(a1,3,3))
05059 = 3/31/1905
How can I...
( 1 2)
|
November 11th, 2009 04:51 AM
by JHL
|
15 |
488 |
|
|
location of a link in server by
Lowan Chan
Hi,
I have an excel file saved at server. I am trying to link some photo files
which are also saved at the same server. But everytime after I save the...
|
|
2 |
205 |
|
|
Loss of Right Button Functionality in Tabs by
Netorius77
I have lost the right click functionality when I right click on an Excel Tab
(Excel 2003)
I can still right click in a cell and get the standard options...
|
|
3 |
195 |
|
|
Conditions by
Jim
Hello,
Thanks in advance for the help.
I want to return the word "TRUE" in column G2 if column A2 shows "SF" and
Column I2 is blank.
If column A shows...
|
|
4 |
242 |