|
|
Counting Rows by
Buster
I tried to create a function to count rows used on a
worksheet and recieved an Overflow(Error 6) message.
Public Function UsedRange()
Dim MyRowCount As...
|
|
1 |
377 |
|
|
DATE by
Gary Reynolds
What function returns the date that never updates; stays
the same?
|
September 17th, 2003 02:23 PM
by Andy B
|
1 |
321 |
|
|
last value in a row by
Cees Bruin
there probably is a fuction which will give me the last
value in a row, the thing is I dont know which one, i use
the max value .. but there could be a problem...
|
|
3 |
381 |
|
|
multiple AND conditions with IF's 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...
|
|
2 |
515 |
|
|
Personal.xls by
Frances
I believe I should have a workbook called "Personal", which I understand
would hold global macros. The equivalent of Normal.dot in word. Where is
mine?
Frances
|
September 17th, 2003 02:59 PM
by Frances
|
3 |
314 |
|
|
barcoding by
Kevin
Please help.
I have added a font to windows to barcode documents. This
font requires an asterisk before and after the value to be
scanned. The value I am...
|
|
1 |
342 |
|
|
LOOKUP or Offeset by
SFrick
I did an earlier post but I guess I was not clear enough in what I
need in a formula.
In cols J through Z rows 6 through 81 is data.
Row 6, J through Z are...
|
September 17th, 2003 03:55 PM
by Will
|
1 |
350 |
|
|
|
|
1 |
335 |
|
|
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 |
270 |
|
|
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 |
252 |
|
|
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 |
794 |
|
|
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 |
357 |
|
|
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 |
309 |
|
|
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 |
468 |
|
|
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 |
334 |
|
|
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 |
340 |
|
|
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 |
612 |
|
|
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 |
304 |
|
|
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 |
351 |
|
|
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 |
306 |