|
|
Rounding up by
Chris
Does anyone know the formula for rounding up to the next
quarters. Example 1.66 should round to 1.75, 2.11 should
round to 2.25. Thanks
|
June 15th, 2004 02:18 PM
by Andy B
|
2 |
398 |
|
|
Naming a range by
Nick Read
I trying to setupa frontpage file that sends data from a
form to microsoft excel file.
Every time I try to do this I am told that the microsoft
excel...
|
|
1 |
430 |
|
|
matching a non-blank by
JulieD
i need to find the cell in a (single row) range that is not blank and return
the cell reference of the cell one row above
e.g.
a b c ...
( 1 2)
|
June 15th, 2004 01:38 PM
by JulieD
|
19 |
651 |
|
|
Web Query Refersh Interval by
Kelvin
Hi
I am using Excel 2002 to get a web query, it work fine but the AUTOMATIC REFERESH Interval is min 1 minute.
I want set the Interval to 20 seconds, can any...
|
June 15th, 2004 11:37 AM
by Kelvin
|
2 |
470 |
|
|
Using COUNTIF with MONTH in formula by
Kevin
Hello,
I have a number of formulas where I use the COUNTIF() formula to
count the number of occurences of a particular item in a range.
Now I would like to...
|
|
6 |
480 |
|
|
Using IF in formula by
I am trying to build up a YTD value in a cell on a
worksheet named YTD. The YTD value is the sum of cell
ref "A17" on each worksheet named JAN, FEB, MAR...etc...
|
June 15th, 2004 10:30 AM
by
|
7 |
418 |
|
|
Printing landscape Excel97 by
Rob Rijs
I'm looking at the following problem: Excel97 on a NT4
Workstation worksheet is setup to print landscape but
the printer (HP Business Inkjet 2250) gives...
|
June 15th, 2004 10:27 AM
by
|
2 |
430 |
|
|
new user desperate for help by
drooby
hello all,
I am wondering if anyone has the answer to this.
my first column A has a lot of repetitive...
|
|
2 |
454 |
|
|
|
|
1 |
1,071 |
|
|
Question by
Alex
I would like to do somethings as follows,
e.g
Sheet 1
a b c d e
1 orange Apple pear grape Pineapple
2 ...
|
June 15th, 2004 07:43 AM
by Alex
|
3 |
384 |
|
|
delete multiple rows by
Continental Translations
I want to delete rows 4,6,8,10,12 etc etc.... So, from row 4, I want to
delete every other row. My rows go up to 4000 or so
Any ideas?
|
|
2 |
488 |
|
|
sum of colors by
borrowedfreedom
I am working in Excel 2003 and have a spreadsheet built that used to sum
up specified colors in a cell with an old version of Excel (used to
have Windows 95,...
|
|
4 |
476 |
|
|
Hyperlinking within a workbook by
keith0628
I have a workbook with more sheets than I can easily navigate through.
I would like to create hyperlinks that jump to other pages, but after
following the...
|
|
4 |
405 |
|
|
|
|
1 |
399 |
|
|
Scrollbar Problem by
The Wonder Thing
Hi, I'm having the age-old problem of having a billion rows on my worksheet for some reason (44327 to be exact), when this particular sheet only uses 263 rows....
|
|
3 |
446 |
|
|
Code wont work "Visible=xlSheetVeryHidden" by
Jonsson
Hi,
I have record this code to get certain sheets hidden. The WB contains a
lot of sheets and I only want to hide some of them.
The code works great as long...
|
|
3 |
491 |
|
|
Selective Workbook Data Summing by
donkirk
I've created a Monthly Plant Activity workbook, with 31 Daily Reports.
Each Daily Report has a list of Serialised Equipment used and the hours
they worked....
|
|
1 |
367 |
|
|
Document not saved by
johnfli
I am trying to save a spreadsheet.
Everythgin seems fine excpet for the message "Document not saved"
Why is it telling me this and how can I save my work?
I...
|
|
1 |
586 |
|
|
Export to DBF by
Paul Masters
I am trying to save a spreadsheet into dbase (dbf) format
but find that cell contents and headers are truncated in
the created file.
any ideas would be...
|
|
3 |
462 |
|
|
Seperating Text Out Of All Text Fields by
Vato Loco
can I use the "find" function using no special text?
I need to seperate the names out of the following string:
first JIM mi T. last JOHNSON
---
Message...
|
|
1 |
536 |