|
|
|
|
2 |
165 |
|
|
can't replace ' by
JulieD
have a worksheet made from imported data - all cells have ' in them (doesn't
show) - need to delete this where the cell is (otherwise) empty - tried find
&...
|
June 17th, 2004 06:02 AM
by Ragdyer
|
1 |
150 |
|
|
MIN IF by
Chris Ashley
Does anyone know of a formula which will give the minimum value of a
range (ex. A1:A200) excluding the zeros (0).
|
|
7 |
211 |
|
|
Frequency Table by
Luke McTighe
Ok, Instead of raw data I have a frequency table, and I want to do a
statistical analysis. For example 100 students take a test with 10
questions and their...
|
|
6 |
306 |
|
|
|
|
4 |
835 |
|
|
"document not saved" by
Raghu Prakash
Hi Ruffy,
SYMPTOMS
When you attempt to save a workbook, you may receive the following error
message:
Document Not Saved
CAUSE
This problem may occur when...
|
|
2 |
435 |
|
|
how to do date 15/06/04 plus 5 months? by
sokevin
hi what formula should i use if i want to work out the date of say
the 15/6/04 plus 5 months from now??
thanks :)
---
Message posted from...
|
June 17th, 2004 07:18 AM
by sokevin
|
4 |
172 |
|
|
Inserting Graphics into Headers by
Jon Teale
Good Morning,
I'm trying (and failing miserably) to insert a graphic into a header in
Excel. I've tried inserting it into the main body of the spreadsheet
and...
|
|
5 |
267 |
|
|
Breaking links on Excell 2000 by
Tony
I have a number of workbooks driven by links with a
central workbook. Some of these workbooks are monthly
monitoring statements that once the month end has...
|
June 17th, 2004 08:38 AM
by Tony
|
3 |
267 |
|
|
Lookup Tables? by
Christine Wilso
I receive data each day exported into an excel file. In column A there
is a list of Areas, in column B a list of months from April to whatever
the month we are...
|
June 17th, 2004 09:26 AM
by Vaughan
|
1 |
137 |
|
|
|
June 17th, 2004 09:32 AM
by Mark
|
4 |
694 |
|
|
Vertical Subtotals by
Gemma
Hello,
I hope I am posting to the correct group.
I have received a spreadsheet from someone that has subtotals in it
(Data, Subtotals), but instead of the...
|
June 17th, 2004 09:56 AM
by Vaughan
|
2 |
211 |
|
|
|
|
2 |
1,276 |
|
|
passwording tabs by
Lee_Woodcock
i know you can password documents, protect cells, and worksheets.
But what i want to know is if you can password certain tabs in the
workbook ? So only users...
|
June 17th, 2004 11:10 AM
by papou
|
5 |
151 |
|
|
Getting External Data by
Andrew
Using Microsoft query I manually edit the SQL to the
following.
select
gl30000.ormstrid as customer,
sum(gl30000.crdtamnt) as credt,
sum(gl30000.debitamt) as...
|
|
1 |
149 |
|
|
|
|
2 |
413 |
|
|
Find next blank row after criteria by
Profairy
I'm really struggling here. I've inherited a very complicated data sheet
that can not be split up in to different worksheets. I have lots of
supplier spend...
|
|
2 |
234 |
|
|
Floating formula bar by
greg7468
Hello all.
Is there a way of defaulting the floating formula bar that pops up
when you select a formula to appear somewhere other than the top left
corner, I...
|
|
1 |
227 |
|
|
|
June 17th, 2004 12:28 PM
by AlfD
|
3 |
577 |
|
|
[URGENT]: Graph x against y problems by
Alireza
Hi there;
I am a newbie to excel would be great if u could help me,
Ok;
I have to sketch the graph of "Log(f) against Phase Shift"
underneath "A" I have put...
|
June 17th, 2004 12:55 PM
by Alireza
|
4 |
247 |