|
|
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 |
460 |
|
|
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 |
642 |
|
|
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 |
424 |
|
|
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 |
390 |
|
|
Excel Query by
Lesley
Hello,
I have a list of around 50 values of which around 40 of
them make up a specific value. Is there a way that I can
find which cells make up this...
|
June 15th, 2004 02:25 PM
by jeff
|
1 |
367 |
|
|
|
|
1 |
371 |
|
|
hour sum setup by
andy
i am currently trying to write an automated wage sheet for my temporary workers. i have finished the sheets and most of the formulas, however i am stuck. if...
|
June 15th, 2004 04:05 PM
by Andy B
|
1 |
419 |
|
|
|
June 15th, 2004 04:10 PM
by JB
|
2 |
716 |
|
|
generalized macros by
vishu
i tried to write a macro for changingthe way the columns are placed on
the excel sheet,but i am not able to make it generalized for every
sheet is use . Can...
|
|
1 |
389 |
|
|
MIN with a condition by
Sarah
I am having no luck writing a formula that will return
the MIN value from column B when column A = "Admin".
Example data:
A B
Admin 5
Mktg ...
|
June 15th, 2004 04:53 PM
by Andy B
|
1 |
373 |
|
|
|
June 15th, 2004 05:18 PM
by AndiB
|
0 |
567 |
|
|
Auto Sum + Conditional Formatting by
BenJAMMIN
I would like to take one cell and have it with the Auto Sum feature. Here's the catch: I have applied a simple Conditional Formatting to a number of cells. The...
|
June 15th, 2004 05:29 PM
by Andy B
|
6 |
654 |
|
|
Format will not save! by
Fred
Win98SE and WinXP using Excel 2000.
I have a CSV file (audit trail from Sage Accts) which will not allow me to
change the format in three particular cells. ...
|
June 15th, 2004 06:02 PM
by Fred
|
2 |
833 |
|
|
|
June 15th, 2004 06:08 PM
by Reems
|
1 |
550 |
|
|
Excel Spreadsheets by
Karen Decker
I have several spreadsheets that are in separate files.
(I need them to be in separate files.)
If I have the same change to all of the spreadsheets, is
there...
|
|
1 |
485 |
|
|
Solver query by
Damien
I'm trying to use the Solver to solve a problem for me,
but even though I've set binary constraints on the
changing cells (ie I want them to be 1 or 0), the...
|
|
1 |
349 |
|
|
replace N/A with blank by
leeners82
I need to create a vlookup function where the following occur:
1) the function looks for a number in the worksheet and if that cell is
blank the cell with the...
|
|
2 |
349 |
|
|
Emergency! Sort Issues by
Sam
I sorted a list in excel - - ascending. Now, I need it to go back to its original order. I did not save a copy before doing this, ugh!
There does not seem...
|
|
3 |
370 |
|
|
Hyperlink by
Nick
Does anyone know why I cant insert a hyperlink in a shared
worksheet?
|
|
1 |
369 |
|
|
Save As using contents of Cell in Name by
NickMinUK
Can someone help with code that changes the "save As" file name to a
combination of the original File Name + the contents of a cell, and
saves file in same...
|
|
1 |
342 |