|
|
What is worng with my formula? by
robert morris
I trying to determine the sum of nine numbers in Row / Column
I12,M12,Q12,u12,y12,ad12,ah12,al12,ap12, minus the two largest numbers of
the...
( 1 2 3)
|
|
21 |
312 |
|
|
Extract two letters by
bm
Trying to extract two letters, the state to be more specific in cells that
have varying lenghts and number of spaces. Examples:
CEDAR RAPIDS IA 52404 USA
...
( 1 2 3)
|
August 11th, 2007 05:56 PM
by RagDyeR
|
21 |
192 |
|
|
|
July 29th, 2007 01:34 PM
by Baffled
|
21 |
276 |
|
|
VLOOKUP by
kyoshirou
i trying to use this forumla:
=VLOOKUP
if unable to find out the values, can the data cells auto set to blank?
( 1 2 3)
|
|
21 |
245 |
|
|
|
July 19th, 2007 09:18 AM
by Bonobo
|
21 |
406 |
|
|
|
|
20 |
483 |
|
|
How to count data in 2 columns by
Ltat42a
Hi All, Can Excel count data that is in two columns? Example, I have a
column of people's names. In the next column, I have a number.
Column A Coulmn...
( 1 2 3)
|
|
20 |
217 |
|
|
How can I delete all macros? by
Pheasant Plucker®
Hi there,
I have an invoice spreadsheet based upon the Village Software invoice.
There is a date cell that automatically puts in today's date but I see...
( 1 2 3)
|
|
20 |
217 |
|
|
|
|
20 |
303 |
|
|
Need Custom format, not a formula by
nastech
060426-5 Need Custom format, not a formula
(Not looking for formula's).
Just need "Custom Format" for how column of e.g.: 1.511B will look like: 2B
That...
( 1 2 3)
|
|
20 |
371 |
|
|
Creating a tick by clicking a cell by
Justin Abel
I have designed a schedule form for my business using excel 2003 and i would
like to know how i can click a cell (a time block) and have it place a
pre-defined...
( 1 2 3)
|
|
20 |
229 |
|
|
time clock formulas by
Andrew
I have created a formula for calculating total hours / day
the times are entered in military time
a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great,...
( 1 2 3)
|
August 9th, 2006 07:56 PM
by Marisel
|
20 |
213 |
|
|
|
|
20 |
383 |
|
|
|
|
20 |
443 |
|
|
more than one IF by
Micayla Bergen
i want my cell to return a value if J5 is 1 or 2 (which themselves are
results of formulas)
i have this thusfar
=IF(J6=1,"SELL?","",(IF(J6=2,"SELL?","")))
( 1 2 3)
|
June 2nd, 2005 07:15 AM
by Max
|
20 |
233 |
|
|
import file by
Mindy
Hi, I have all of my personal addresses in an AnyTime file. I have exported
it as a .csv file. I then open Excel and when I try to import it, it says
cannot...
( 1 2 3)
|
|
20 |
367 |
|
|
BIMDAS - Order of Calculation by
Atreides
I've recently noticed that Excel flies in the face of standard scientific,
mathematical and engineering convention in the calculation of powers for
numbers...
( 1 2 3)
|
February 23rd, 2005 02:33 AM
by Atreides
|
20 |
541 |
|
|
Finding last row in a column by
daniel chen
Column A contains entries of any formats including blanks.
My objective is to find the last blank row# in Column A, and post it in cell
D1.
Can you help me...
( 1 2 3)
|
|
20 |
326 |
|
|
|
|
20 |
717 |
|
|
Can Only Be Done One Way ! by
RagDyeR
We are all aware of the numerous ways that "things" can be accomplished in
XL.
Does anyone know of *anything*, that can only be accomplished using...
( 1 2 3)
|
|
20 |
506 |