|
|
|
November 27th, 2004 04:23 AM
by Biff
|
2 |
372 |
|
|
Page Size Default by
Bert
Hi,
I have tried going to Page Setup on an Excel 2003 sheet and changing
envelope to 8 1/2X11 sheets. I cannot make it default to 8 1/2 X 11. Every
time I...
|
|
1 |
86 |
|
|
AUTO HIDE ROWS by
Alan
Is there a method/function to auto hide rows dependent on the value of a cell
in that row ...
Ie cell B3 = 0 ...... hide row ??!
Many thanks again
Alan
|
|
1 |
197 |
|
|
IF AND function by
Chink!
Hello
I'm trying to write a formula for the following:
If the value in cell B8 621
AND
if the value in cell B21 3000
value = YES
|
November 27th, 2004 09:28 AM
by Chink!
|
7 |
85 |
|
|
SumProduct/Date Ranges by
wal50
This statement returns the correct result for records meeting these
conditions and dated before...
|
|
3 |
86 |
|
|
extracting dd from dd/mm/yy by
KC
Hi,
How can I extract the day from the date, ie date is "31/12/04" - need
"31" returned in an adjacent cell.
I need to have "31" returned as a numeric tho...
|
November 27th, 2004 12:57 PM
by Max
|
4 |
98 |
|
|
Match & Index by
Phyllis B.
Here's the scenario:
A B C
1 10 0
2 20 1
3 30 2
4 40 3
I want to...
|
|
2 |
449 |
|
|
Pivot Table by
wal50
I can't get a sum on a Currency formatted field in the table. I can get an
Item count. Suggestions are most welcome.
wal50
|
November 27th, 2004 03:41 PM
by wal50
|
2 |
84 |
|
|
|
November 27th, 2004 03:50 PM
by Daniel.M
|
8 |
141 |
|
|
Identify missing criteria by
Farmer Mark
I am an experienced excel user, but stuck in the same basic functions.
I am trying to move my skills to the next level, and am currently
building a model which...
|
November 27th, 2004 04:23 PM
by JulieD
|
3 |
102 |
|
|
|
November 27th, 2004 05:53 PM
by Todd F.
|
6 |
391 |
|
|
i special paste by
Sweenythe barber
I could tranform an excel page via special paste (transform)
special paste now seems to have changed there is no transform
can I do this a different way
|
|
2 |
216 |
|
|
Copying from list by
Mortthesport
In Excell, I would like to be able to copy from a list simply by clicking on
cell and dragging the info to a new cell without losing the info from the
original...
|
|
1 |
125 |
|
|
|
|
3 |
335 |
|
|
Macro Formula revision? by
Mark
Forum,
How do I change the Macro so when I run the macro again to update values I
added to my source sheet I will get the correct update.
Everyday I add to...
|
|
1 |
325 |
|
|
|
|
2 |
453 |
|
|
subtracting times using 24 hour clock by
andrew pronto
I want to calculate a period of time in 24 hours to be able to work out the
running speed of a machine. This is ok using say 18:00 to 21:00 the resulting
time...
|
|
6 |
148 |
|
|
Drop down list question... by
GR
Here is one for you... I want to make a workbook with the following
ability.
Pick an item from that drop down list in column "A" and it shows a price
in...
|
|
2 |
109 |
|
|
auto filter question by
Juco
A column in spreadsheet.... If I want to auto filter I go to Data/Filter
/Autofilter....This is fine except that having done that the arrow for auto
filter...
|
November 28th, 2004 02:51 PM
by tjtjjtjt
|
1 |
225 |
|
|
"Vlook up + IF" by
paula smith
I have created a function "vlook up" which worked fine,
however I would like to add the function "if" to avoid
have some cells N/A instead of a number...
|
November 28th, 2004 03:20 PM
by Rob
|
2 |
181 |