|
|
|
|
21 |
521 |
|
|
Why does this formula not work? by
dk_
Why does this time formula *NOT work* if I leave out '(E8D8)'?
The formula works normally when written as below...
=(E8D8)+E8-D8
When I leave out...
( 1 2 3)
|
September 28th, 2006 09:18 PM
by dk_
|
21 |
240 |
|
|
Auto-filter question by
Dallman Ross
Can auto-filter be engaged for a column, yet not have the
pull-down arrow showing? I'd prefer that. Or can one
mix advanced filtering and auto-filter?
I'm...
( 1 2 3)
|
|
21 |
468 |
|
|
Find last instance of character in text by
KonaAl
Hi All,
I need to be able to return an account number (7 digits) from a text string.
The account number is preceded by a colon. I'm very familiar with...
( 1 2 3)
|
November 28th, 2006 06:59 PM
by T. Valko
|
21 |
218 |
|
|
|
|
21 |
203 |
|
|
|
May 1st, 2007 03:29 AM
by Joe
|
21 |
178 |
|
|
Discussion group problem - my computer? by
ShaneDevenshire
Everytime I send a query to the newsgroup I get the follow screen:
"Communities E-Mail Notification
Thank you for taking the time to fill out the...
( 1 2 3)
|
|
21 |
277 |
|
|
IF statements - 26 combinations by
Rajula
I have to incorporate this in a IF statement or whatever is simple. Does
anybody have a simple solution for this?
Cell A1 can have 5 values A,B,C,D or E
Cell...
( 1 2 3)
|
|
21 |
236 |
|
|
Disable keyboard shortcuts by
Pegasus
I use some keyboard shortcuts that are global to Windows,
e.g. Ctrl+; to generate the letter "ö". This does not work in
Excel because Ctrl+; inserts the...
( 1 2 3)
|
|
21 |
225 |
|
|
|
April 27th, 2010 10:05 PM
by Rodrjua
|
21 |
443 |
|
|
|
|
21 |
1,697 |
|
|
Negative Numbers in Brackets - HELP! by
Hélène
Hi,
I have read every questions and replies on this site in order to get my
negative numbers to show in brackets and nothing works. I am desparate. ...
( 1 2 3)
|
|
21 |
459 |
|
|
How to calculate date and time by
kasey
please help me in something
i have two cells:
31/10/2004 18:00
01/09/2004 07:00
i want to subtract the two cells
the result i am taking is 29/02/1900 11:00
but...
( 1 2 3)
|
|
21 |
342 |
|
|
How to refer to every 5 th cell? by
R.P.McMurphy
I'm currently working with this array formula...
=SUM(IF(G4:BJ4C4,C4,G4:BJ4))*0.09615
How do i change this so that G4:BJ4 refers to every 5th cell staring...
( 1 2 3)
|
August 27th, 2005 06:13 PM
by RagDyeR
|
21 |
208 |
|
|
|
|
21 |
296 |
|
|
Linking formula by
Jonibenj
I have two sheets, and I want to link information from one to the other.
The difficulty is that on sheet 1, the data is entered in every
consecutive cell down...
( 1 2 3)
|
September 15th, 2005 01:52 AM
by Max
|
21 |
221 |
|
|
|
|
21 |
223 |
|
|
mail merging 2 workbooks??? by
Bubba Gump
ok, my title may not be accurate but I wasn't quite sure what else to call
it. I have a workbook created that is a page layout of a bunch of different
fields...
( 1 2 3)
|
August 7th, 2006 09:13 AM
by Gocool
|
21 |
326 |
|
|
Tricky Formula by
andrewc
Hi,
I have column of monthly investment returns. If the return for a
particular month is less than zero I want to regard the return for that
month as zero but...
( 1 2 3)
|
|
21 |
207 |
|
|
corrupted formula in protected worksheet by
Tom-S[_2_]
Is there any way (in Excel 2003) in which a formula in a locked cell of a
password protected worksheet can end up corrupted, without the sheet having
first...
( 1 2 3)
|
|
21 |
1,184 |