|
|
testing by
testypants
does this thing work????
|
|
1 |
397 |
|
|
Formatting (General to Number) by
Tom R
Does anyone know if there is a way to change the number formatting from
General to Number in one shot? I have an entire column that is in general
formatting,...
|
|
5 |
1,052 |
|
|
MouseClick as Counter by
David Webster
Is there a way to add code so that you add one to every cell you click on
within a range?
E.g. any cell between say C3 to H20 when I clik it I want it to...
|
|
1 |
324 |
|
|
Pivot Table Display by
td
I have created a pivot table with the following
parameters:
Page Area = Customers
Row Area = Product
Column Area = Month
Data Area = Sales $
When I select a...
|
|
1 |
275 |
|
|
sumproduct variables by
Tony
Hello Group,
How do I include multiple cell reference variables in a
sumproduct function? For example, if I wanted to include
text values I would use...
|
|
7 |
436 |
|
|
Multi worksheet data look up by
Ray
I am looking for a way to copy data from multi worksheets
to another worksheets.
I have 50 worksheets of data and what to copy an area of data
from any 1 of...
|
|
1 |
524 |
|
|
emailing protected Excel worksheets by
R Maule
when attaching a password protected Excel worksheet to an
email, the password protection is not transferring. have
attempted using Microsoft Outlook with the...
|
|
1 |
425 |
|
|
sequential counter by
David Webster
I have a column of species and a row of plots as follows:
PLOT: 1 2 3 4 5
Spp1
Spp2
Spp3
Spp4
Spp5
....
to Spp 150
|
September 17th, 2003 07:34 PM
by 2rrs
|
4 |
301 |
|
|
nested functions by
Linda
I am trying to create a nested function that returns a
value of a bonus figure paid at
5% over a certain amount e.g .total sales over 2000 and
2% at a lower...
|
September 17th, 2003 07:26 PM
by Nathan
|
2 |
347 |
|
|
LOOKUP function by
Rod
When I use the LOOKUP function with the following
argument =LOOKUP(D4,$A$28:$A$47,$B$28:$B$47) where
D4=3.6 and the lookup_vector and result_vector looks...
|
|
3 |
302 |
|
|
copying worksheets to other workbooks by
Roy
I have a workbook with formulas that reference sheets
(tabs). I want to copy the formulas to another workbook
with the same tab names and have the formulas...
|
|
1 |
608 |
|
|
If then formula by
Paul B
Have a look at VLOOKUP in help and see if this will do what you want
--
Paul B
Always backup your data before trying something new
Using Excel 97 &...
|
|
3 |
334 |
|
|
Deleting Excess Pages by
Mai
I made a 1 page document in Excel. When I go to print this
one page it prints an excess of 60+pages. How do I get rid
of those pages? I know that I can print...
|
|
1 |
328 |
|
|
Using multiple IF statements by
David
I have to create a column that shows traffic movement data.
I'm not really used to Excel and this is the formula I
have come up with thus...
|
September 17th, 2003 07:05 PM
by Ray
|
4 |
466 |
|
|
histogram by
Im trying to make a histogram, and i can't get it to work
at all. I go to tools, data analysis, select histogram,
and then i have no idea what to put into the...
|
September 17th, 2003 06:57 PM
by Tom
|
1 |
302 |
|
|
Turn off From: Cc: options under Office by
Carl
A user using excel and work encountered a spreadsheet that
was sent to them added the ability to send from these
platforms.
How does one remove these options...
|
September 17th, 2003 06:29 PM
by Carl
|
0 |
352 |
|
|
using spell check on a protected sheet by
Scott
Lauren,
Same problem; I've tried every variant of sheet and
workbook protection. My searches at microsoft.com KB/sppt
yield no solution (nor does this...
|
September 17th, 2003 06:19 PM
by Scott
|
0 |
791 |
|
|
If then formula by
photohoward1
I am writing a spread sheet to keep track of a racing
club. I would like to be able to enter the place of finish in
one cell and have the points automatic in...
|
|
0 |
246 |
|
|
graphng distributions by
leslie
I am graphing standard normal distribution, i.e.
bell-shaped curves. How can I shade an area under this curve?
|
|
1 |
266 |
|
|
|
|
1 |
330 |