|
Please do not remove "Address" command from Excel 2007
I am a Microsoft employee. The "Address" command from Excel 2003 was
extremely helpful for me to copy & send links to Microsoft counterparts that
have access to local server without sending big files by e-mail. The
"Location" in Excel 2007 does not provide full file path which is very
inconvenient; please do not remove a helpful feature that already exists in
Excel 2003! Thank you.
...
|
1 |
25.09.2006 09:34:02 |
|
|
Automotive 5 Year Depreciation
Hey Guys:
Can one of yuz take a look at this formula related to a 5 Year Automotive
depreciation factor?
Here it is:
21,000 Initial cost =A12
2,100 Salvage value = 10% =A13
5 Lifetime in years =A14
Description (Result) are based on a purchase in July
$3,907.75 1 Yr =DB(A$12,A$13,A$14,1,7)
$5,452.43 2 Yr =DB(A$12,A$13,A$14,2,7)
$3,713.10 3 Yr =DB(A$12,A$13,A$14,3,7)
$2,528.62 ...
|
7 |
25.09.2006 09:32:39 |
|
|
how to make an function to list all the same records
Good day!
I want to make a function formula instructing to list down all the same
records based on the inputed by the user, the thing I can't solve. Below is
the table example.
Table:
A B C D
1 ID NUMBER NAME Course Points
2 1000218 Mandy BS Computer Science 5
3 1000214 J...
|
7 |
25.09.2006 09:10:21 |
|
|
Displaying all numbers as positive
Ok hope you guys can help:
A1= x
A2= y
A3= A1-A2
If the answer is a positive number I want it to remain as a positive
number
-but-
If the answer is a negative number, I wish for it to be displayed
without the "-" sign before the number so it looks like it's a positive
number. But I also want it to hold it's negative value so that it can be
used later on.
Example:
A1= 5
A2= 8
A3= A...
|
3 |
25.09.2006 09:01:30 |
|
|
CSE formulas
Dear friends, I`m currently using CSE formulas to extract and analyse data
with the multiple criterias. e.g:
=SUM(('12SP'!$A$2:$A$65536=$A$1)*('12SP'!$G$2:$G$65536=$C$6)*('12SP'!$E$2:$E$65536<=$D$2)*('12SP'!$D$2:$D$65536))..But
unfortunately I have a problem with sheets so that everytime I face the
calculating cells %0..%100 phrase when I make any change. Perhaps it`s
because of heavy...
|
5 |
25.09.2006 07:46:18 |
|
|
How to switch negative numbers to positive numbers in Excel ?
Need to switch positive numbers to negative numbers (or vice versa) in Excel
worksheet efficiently, anyone can help me here?...
|
3 |
25.09.2006 05:34:18 |
|
|
how do i delete rows that end in SMPT
i am trying to clean up my excel data base. I want to delete all rows tha end
in SMPT. How can i set up the Column to do this easily instead of one by one....
|
2 |
25.09.2006 05:24:01 |
|
|
Hlookkup/Match won't work
Hi there. Any help much appreciated
My formula HLOOKUP(P21,Levels!$C$7:$O$1800,MATCH(O21,Levels!$A$7:$A$1800))
has worked fine for the last 10 years. All values in cells C7:O1800 have been
>0.
My problem is, I now need to add a mixture of negative values (-20) to the
above range and my formula just won't return the negative value
I have tried the following formula to test
=IF(H...
|
5 |
25.09.2006 04:21:25 |
|
|
Unlocking cells
Hi,
I have a spreadsheet but a few of the cells have been password
protected. The person who created it has long gone and took the
password with him, does anyone know how I can unlock those cells. I am
a relative novice. Thanks
--
Vanilla Skies...
|
2 |
25.09.2006 03:30:12 |
|
|
Flashing cell for conditional formatting as an option
This would be very nice for those involved in the financia lindustry who use
a DDE to monitor stock and futures pricing.
Under certain conditions the cell would flash
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see th...
|
2 |
25.09.2006 03:24:10 |
|
|
formula to choose a hyperlink from a cell
I have a cell which contain a hyperlink.
Now I want a formular to pick the hyperlink in this cell.(result is a text)
Example:
cell A1: "Music" (it was formated as blue and underline by Excel) and
have a hyperlink: "C:/my music/music.html"
Now I want cell A2 have text "C:/my music/music.html" (use a formula to do it)
Sorry for my English
Thanks....
|
2 |
25.09.2006 03:13:11 |
|
|
SUMIF with the Sum_range across several colums
I would like to use SUMIF to add up numbers occurring in a row that spans 12
columns (months of the year) if the condition is met in the same row in
another column.
This is how I tried it: =SUMIF(B2:B13, "=STA", H2:S13)
The conditon STA can appear in several rows in the range in column B.
It works perfectly if there is only one column in the sum_range, but not
with more than one.
...
|
8 |
25.09.2006 03:00:19 |
|
|
Coumn/Row highlight tracker
I use spreadsheets that can be very wide and long and I would love a means to
highlight the cross rows and columns of the cell I am in.
This has been done through the use of macros and some third party software
(Rowliner) but it would be a great tool to be implemented in Excel itself.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions...
|
1 |
25.09.2006 02:23:01 |
|
|
npv calc for customer pay plans
I'm thinking that everytime we offer a pay plan to a customer, we lose
money by not collecting payment (premium, since I am in the insurance
industry) in full at the time of sale based on either a present value
or npv calculation. I would like to be able to calculate that loss for
various terms offered, i.e., 25% and 9 installments, 20% deposit and 8
installments, etc. While I think that my o...
|
2 |
25.09.2006 02:02:56 |
|
|
Formatting to show 0 as first number in a cell when input
How do I format a cell so it automatically shows a 0 as the first digit when
I input a numeric value insted of using the ' prefix? The cell is used for
order numbers which can begin with a 0...
|
6 |
25.09.2006 01:56:56 |
|
|
Employee Tracking
I need to create a Employee specific worksheet. The information I need is
based off of a daily production worsheet. I can not figure out a formula to
use. I need to have a total if the employees name is entered. This would
have to be the result across 30 other worksheets. I tried this one, with no
luck: =SUM((Day1:Day31!C5="Alex")*(Day1:Day31!C6)). Hopefully this givs the
idea of what I...
|
12 |
25.09.2006 01:31:56 |
|
|
Worksheet Colour
How do I change colour from a white sheet to black?...
|
3 |
25.09.2006 00:42:26 |
|
|
How do I fix loosing 1st digit in zip code in mail merge?
I have a spreadsheet with headers for a mailing. When I do the mail merge
the first digit in the zip code is dropping off. I have the cells formated
for zip code and it is still doing the same thing. Working with Office 2003....
|
2 |
25.09.2006 00:41:30 |
|
|
How do you get the values of the data between data points
I am using excel to make a line graph with two lines. The two lines cross and
I want to know the exact point where the lines cross, however can't get my
computer to trace either line to figure out the exact point. ...
|
2 |
25.09.2006 00:41:01 |
|
|
I'm going crazy, Excel returns 0 for a simple sum
all i am trying to do is add j82 and k82 excel is returning a value of 0.
First i thought the formula was incorrect =j82+(k82/100) but that was not it.
Next i check the format of what's being added, they were all set to number,
no problem there. Next I Evaluate Formula this is where i am losin my mind it
steps me through the process
=J82+(K82/100)
=12243+(K82/100)
=12243+(72/100)
=1224...
|
5 |
24.09.2006 23:30:04 |
|
|
Upper case text
I'm trying to convert an existing spreadsheet with 600 rows of data to upper
case text...
|
2 |
24.09.2006 19:13:03 |
|
|
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...
|
2 |
24.09.2006 18:54:01 |
|
|
chart or macro problem
hi
problem: Have around 300 student records want to produce a chart for
each one, the chart contains 4 pieces of data for each student and is
unique to each student, I want to produce a seperate excel template for
each student e.g. i will end up with 300 seperate excel files prefably
called the students name??
any help would be gratefully received
cheers
paddy
...
|
2 |
24.09.2006 17:55:49 |
|
|
Need to sum a column if two cells in row are equal
I need help - I actually am trying to do two separate functions, but I
think the formula should be similar for both.
#1: I am trying to sum a column if two cells in each row are equal.
For example:
Date N. Hours D. Hours Total
Row1 1/1/2006 3 1 4
Row2 4/4/2006 2 ...
|
2 |
24.09.2006 16:36:02 |
|
|
How to display month only for date format?
Does anyone know how to display the month only for date format?
such as 26 Sep, 2006, it displays Sep only.
Thank you for any suggestion
Eric...
|
2 |
24.09.2006 14:06:50 |