|
|
removing alpha by
MBD
I have a cells that have numbers and alphas...for example, 1A, 1B, 1C.....in
order to join this table to a corresponding table in GIS, I need to remove
the...
( 1 2 3)
|
|
23 |
246 |
|
|
another IF query ...... by
englishrose4719
How do I work this one out please?
IF 'A20' is not null AND 'A16' is null OR 'A17' is null then COUNT result in
'A14' on a different spreadsheet!!!!!
help...
( 1 2 3)
|
May 18th, 2007 11:03 AM
by CLR
|
23 |
245 |
|
|
sumproduct!!! by
nowfal
Hi,
In the first sheet, i have the following...
( 1 2 3)
|
|
22 |
307 |
|
|
|
|
22 |
247 |
|
|
my impressions of Excel 2007 by
T. Valko
I finally broke down and installed Excel 2007...
The ribbon isn't horrible but it'll take some getting used to. Kind of
reminds me of a video game.
I've...
( 1 2 3)
|
|
22 |
197 |
|
|
sumif with 3 condition - urgent by
RKS
Hi all
I have protect excel sheet1, which we have enter data in many column.
I have create another sheet2 for summery. here we have use 2 criteria like...
( 1 2 3)
|
|
22 |
180 |
|
|
Determining a leap year by
ARGT
I want to calculate a daily interest rate from an annual rate. I have input
the following formula into a cell labelled "Days in the Current Year" :...
( 1 2 3)
|
|
22 |
322 |
|
|
|
July 10th, 2008 04:17 PM
by RagDyeR
|
22 |
263 |
|
|
time format by
art
Hello:
I have the vba code below but I need some changes. I want to make that when
I enter in a cell 5a it should automatically format it to 5:00 AM and when...
( 1 2 3)
|
|
22 |
176 |
|
|
Formula required. by
sherbrooke[_2_]
I have rows of figures over a number of columns, starting at column A,
with totals for each row in column K. I then want to allocate values
from 1 to 8 to...
( 1 2 3)
|
|
22 |
199 |
|
|
Can I Make This Computation Shorter? by
Steve[_29_]
I have a column (A) of stock prices. In the next column I copy down the
formula:
=(A7/(MAX($A$5:A7))-1)^2
all the way to
=(A57/(MAX($A$5:A57))-1)^2
I then...
( 1 2 3)
|
|
22 |
182 |
|
|
Moved files and can't find them by
Irene
I moved all of my related 2006 files/folders to a single folder "2006". Now
when I go into this "2006" folder that has all of my work for last year I get
an...
( 1 2 3)
|
|
22 |
178 |
|
|
$ - 0.00 nevgative zero by
Michele
for some reason my formulas are returning a $ -0.00 instead of $0.00 like it
has always done before. How on earth do i have a negative zero. Zero is...
( 1 2 3)
|
|
22 |
302 |
|
|
data gets rounded up !!! by
Dr Alok Modi MD
I have devised a workbook where I enter the credit card details of the
transactions received at my hospital for people who pay by credit card. In
this there...
( 1 2 3)
|
|
22 |
181 |
|
|
Merged cells won't Autofit row height by
Hpyifur
When I merge cells and then choose the wrap text option the Autofit function
no longer works. Is there a way to get around this without manually sizing
the...
( 1 2 3)
|
July 20th, 2009 10:43 PM
by Jeno
|
22 |
601 |
|
|
Help - Daughter by
newbie
My daughter is taking an excel class - she needs help with this story problem
- can anyone assist us on getting her started.
Manager of furniture store is...
( 1 2 3)
|
January 2nd, 2007 04:21 PM
by Curt
|
22 |
542 |
|
|
Excel Sorting help by
[email protected]
I hope someone can help me with this as simply as possible. I would
prefer to stay away from VB (don't know how to use it very well), but I
will do what I...
( 1 2 3)
|
September 9th, 2006 01:04 AM
by Max
|
22 |
222 |
|
|
|
April 26th, 2006 01:25 PM
by duugg
|
22 |
375 |
|
|
Macro for hiding rows by
Luke
I have a spreadsheet which contains a lot of rows with no data, I would like
to create a macro to hide these rows.
Preferably I would like it to work off one...
( 1 2 3)
|
December 24th, 2005 03:40 PM
by KL
|
22 |
321 |
|
|
|
July 29th, 2009 10:58 PM
by Joel
|
22 |
270 |