|
formula help
...
|
1 |
25.09.2006 14:00:02 |
|
|
Window XP update has caused excel to not operate
I recently allowed an automatic "updates are ready for your computer"
process. After a couple of weeks, I tried to access my excel program it
appears to have been deleted. When I use the desktop icon, it begins an
installation process and then looks for an installation disk (which I don't
have).
Any suggestions?
...
|
3 |
25.09.2006 13:58:02 |
|
|
Setting up templates with formats
I need to set up a template in Excel 2003 that receptionist can access for
entering messages for certain department. I want to be able to set formats
(font, size, style etc.) that no one else can change.
Can you please help?
Michelle...
|
1 |
25.09.2006 13:50:02 |
|
|
Excel formula needed
Can somebody help me out with this formula that has been driving me mad for
the last week.
A
1 100
2 15%
3 85
I need a formula to put into A1 based on the figures in A2 and A3 so that
A1-A2=A3. A3 and A2 are known but variable amounts.
many thanks, Les....
|
5 |
25.09.2006 13:44:02 |
|
|
Excel spreadsheets print too small on the page.
I’m using Excel 2004 for Mac, v 11.1.1. My spreadsheets look normal on
screen, but print very small—covering only 2 inches by 4 inches of the page.
I tried setting the print area to the area I’m using, and adjusting the Page
Set-up to both 100% and Fit to 8 x 11, and neither worked. Can anyone help?
Thanks....
|
1 |
25.09.2006 13:43:02 |
|
|
msquery
I am interested in creating a field in query based on the values in
existing fields. If the value in field A = 'Y' then insert value in
field B, else do nothing. I get syntax errors, but nothing that is
helpful to correct the 'error'.
--
troestj...
|
2 |
25.09.2006 13:31:02 |
|
|
Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error
Here is the code:
Dim A As String
A = Range("J3").Value
ActiveSheet.Select
ActiveSheet.Copy , Before:=Sheets(1)
ActiveSheet.Select
Active.Sheet.Name = A
Range("F5").Select
The value in J3 is 10-02 (formatted as text using =TEXT(F4, "MM-DD").
It runs fine until the line "Active.Sheet.Name = A" and then stops with
a 424 error "Object Required". Up to this p...
|
5 |
25.09.2006 12:35:02 |
|
|
Excel file access password
I have excel files that I am selling to clients. I have seen other excel
templates that have features that I need such as: 1) You cannot copy the text
from the screen 2) You need a password to access similar to registration of
new software 3) Allows a 30 day free access then it become unavailable. Does
excel itself have these features or do I need to buy some other software?
--
James A...
|
3 |
25.09.2006 12:34:01 |
|
|
Excel Hyperlinks..how to get rid of them
I have a simple excel spreadsheet. My spreadsheet includes Company name ,
contact name , email address.. and sometimes the company website.
After a few weeks of adding companies, I have hyperlinks all over the place,
it is hard to click in any cell anymore , as it will go to the email or a
webpage.
my problem does not stop there, I have a new company that I have added, and
I will click ...
|
4 |
25.09.2006 12:11:02 |
|
|
2006 West Coast Excel / Access User Conference
2006 West Coast Excel / Access User Conference - October 25-27, 2006
http://www.exceluserconference.com/WCEUC.html#Tentative_Schedule
Mike Alexander
Alison Balter
Dick Kusleika
Simon Murphy
Jon Peltier
Bob Umlas
The regular registration period is coming to a close on September 30th. Be
sure to register this week if you would like to get in before the late
registration period begin...
|
1 |
25.09.2006 12:09:00 |
|
|
Refresh the series in the chart...
Hello Experts ..
1. I have a worksheet, Col 1 Year, Col 2 Target, Col3 Actual data of a
products (separate sheet for each product)
2. Data from external DB is populated in Excel.
3. Excel is used to generate the trend chart and bar charts etc.
4. Since the source data (number of rows change in excel) the graph also
changes every time(Number of rows used for chart might increase or decrea...
|
1 |
25.09.2006 11:56:02 |
|
|
Negative numbers in brackets
I cannot find an option for showing negative numbers in brackets when I go to
Format, cell, number. The only choices I find are either to show with minus
sign or in red. Any suggestions would be welcome....
|
5 |
25.09.2006 11:34:06 |
|
|
SUMPRODUCT clue needed
Assume a table of data sort of like this:
A ... G ... O P
1 Stock Cost Running Avg Nominal Rate
Return by Issue of Return
2 Foo 3555.20 6.77% 6.77%
3 Foo 3225.29 2.23% -2.30%
4 Foo 2708.08 2.39% 2.71%
5 Foo 3838.93 ...
|
6 |
25.09.2006 11:29:19 |
|
|
How do I produce Automatic Quotation Numbers in Excel?
Hi. I am building a quotation system in Excel and have to file away, and be
able to bring back up specific quotations. To do this, I presume I need a
unique quotation number. How best should I do this? Thanks...
|
3 |
25.09.2006 11:16:01 |
|
|
EXCEL ONLINE MULTI ACCESS
Just a curiocity.
Google's online Spreadsheet - <www.spreadsheets.google.com>, is the latest
sensation in spreadsheet world. Further I have see few more online
spreadsheet softwares.
DOES Excel of Microsoft has any idea of making their Excel as online
shareable product.
If they do it will be wonderful, any ideas.
best wishes..
----------------
This post is a suggesti...
|
3 |
25.09.2006 10:56:02 |
|
|
Running total of last 6 months in rows
...
|
1 |
25.09.2006 09:31:01 |
|
|
Lookup 2 values
Can anybody help me with a formula to lookup 2 values simultaneously like
Account No. and Sub Account No.?
Thanks in advance.
Jaleel...
|
13 |
25.09.2006 07:49:38 |
|
|
formatting rupees
I need to custom format a cell to read 00,00,000, instead of the usual comma
after three spaces.
This is for an application that uses Rupees, which have a comma break at
1,000, then the next 100, and then another 100. In other words, whereas 10M
would normally print "10,000,000", I need it to print "100,00,000". Further,
I need every 1,000 after this to be at the three digit mark. In...
|
9 |
25.09.2006 07:48:45 |
|
|
invalid references in formula
I got the following message in excel:
"A formula in this worksheet contains one or more invalid references.
Verify that your formulas contain a valid path, workbook, range name and
cell reference."
How do I check and fix the error?
Thanks!...
|
3 |
25.09.2006 07:04:01 |
|
|
WHY I CANT FIND THE FILL SERIES OPTIONS IN EXCEL?
WHY I CANT FIND THE FILL SERIES OPTIONS IN EXCEL?...
|
2 |
25.09.2006 06:52:01 |
|
|
Formula structure, maybe not parenthesis, CELL()?
060925 Formula structure, maybe not parenthesis, CELL()?
hi, have formula that is combo hyperlink to (this case) min value in column
range.
have start & stop rows selected in original formula that works.
(both branches are same range att, doesn't matter now)
trying to double up with simple choice: IF($BQ$11="x",
then use 1st, or 2nd range; chose 2 branch method (2 areas).. instea...
|
2 |
25.09.2006 06:29:02 |
|
|
adding words
Hi everyone
this is my problem.
In a excel sheet there are many different words in several cells.
i want a way to add a spacific word and get the total number of times this
word appears in the sheet.
For example...
the word "office" appears many times in the sheet and i want a way to show
me how many times this word appears in number.
thanks.. ...
|
2 |
25.09.2006 06:16:01 |
|
|
How to code it in excel?
Could anyone please give me any suggestion on how to code following condition
in excel?
In colume A, it displays the date for activities.
In colume B, it displays a list of activities for everyday, such as input
products, output products and keep inventories. The number of activities is
not fixed, one day could performance 6 activities, but on the other days, it
could performance 9 a...
|
5 |
25.09.2006 05:46:02 |
|
|
Function Help
I would like to design a function that will select a range of cells and
assign an alternating color (light gray & no fill) to the rows within that
selection after a copy, cut or paste operation occurs. Anyone have any ideas?
Thanks,
Kevin...
|
8 |
25.09.2006 04:21:38 |
|
|
Creating a Default Border Style
I am using Excel 2000 and would like to know if it's possible to change the
default border style to the hairline option (the one immediately below the
'none' option in the Format Cells window)? I currently have the border icons
on my toolbar, but they are set to the thin solid line. Is there a way to
change it, so that every time I click on these border icons, it's always the
hairline ...
|
1 |
25.09.2006 03:06:02 |