|
|
Help with a formula. by
I am trying to simplify a formula on a worksheet that
sums the same cell on 50 other worksheets all within the
same workbook. I can do it the long way of...
|
September 25th, 2003 04:43 AM
by
|
2 |
142 |
|
|
funcres.xla by
funcres.xla is not found on my pc so analysis toolpak
(yield, regression) do not work. where can I get funcres;
download? tks mike
|
|
1 |
249 |
|
|
|
May 30th, 2004 09:32 PM
by
|
4 |
135 |
|
|
EXCEL Help Please by
When i do my accounts like so 150.00 and press enter to
add the total the decimal point changes to a square.
|
June 1st, 2004 05:19 PM
by
|
3 |
116 |
|
|
|
|
4 |
152 |
|
|
Blank Cell by
Hello from Steved
The formula below works,
=HOUR(IF($T$40.5,$T$4-0.5,IF($T$41/24,$T$4+0.5,$T$4)))
&TEXT(MINUTE($T$4),"00"))
but when I add...
|
June 25th, 2004 10:27 PM
by Steved
|
5 |
141 |
|
|
How do I format by
I have a page of marketing leads with names, addresses,
phone numbers, etc all running togeather on a MS Word doc.
I want to copy it to a MS Excel spread sheet...
|
July 5th, 2004 02:10 PM
by papou
|
1 |
104 |
|
|
|
July 15th, 2004 10:43 PM
by hgrove
|
1 |
123 |
|
|
Trim leading zeros by
How do I trim leading zeros from a cells?
000000023
000000003
000000010
Thanks!
|
|
2 |
320 |
|
|
selecting certain rows by
I have a macro that selects rows based on their data.
IE.
x = Application.WorksheetFunction.Match("AIR", Range
("J:J"), 0)
y =...
|
May 30th, 2004 02:43 AM
by DK
|
3 |
174 |
|
|
Drop-down List by
Go to Data- Validation and then you will choose List
(where you will hard code the values in the drop down).
Hope this helps.
-----Original...
|
|
1 |
160 |
|
|
Indirect Funtion by
Is there a way to fill down and right a cell that has the
Indirect Function in it that alters the second cell
referrence.
As an example, if the first funtion...
|
October 24th, 2003 08:23 PM
by
|
2 |
190 |
|
|
|
|
4 |
122 |
|
|
|
|
1 |
466 |
|
|
my arrow keys!!!! by
my arrow keys are shifting my entire workbook columns/rows
instead of just moving from cell to cell! how do i fix
this?
|
January 20th, 2004 03:19 AM
by RagDyer
|
2 |
420 |
|
|
Hide Column Help Needed! by
-----Original Message-----
Hi,
I hid two columns in my excel spreadsheet and now I want
them back. How can I do this?
Please...
|
January 21st, 2004 06:23 PM
by
|
0 |
114 |
|
|
|
March 25th, 2004 10:43 PM
by
|
0 |
214 |
|
|
column comparision counting. by
I have a spreadsheet that i need to compare columns.
in column a is the lookup value.
in column b,c and d is data to compare to column a
i want to compare...
|
|
7 |
499 |
|
|
Month calculating by
=3DDATEDIF(A5,A66,"M")
A5 =3D first date
A66 =3D second date
M for months
Should work.
Nav.
|
April 22nd, 2004 01:24 PM
by
|
0 |
111 |
|
|
excel formula by
I have a spread sheet in which column A has Account
numbers and also Salary. So A1=Smith and A2=5,000. and
so on. In another sheet, I would like to have...
|
|
1 |
94 |