|
|
|
|
4 |
195 |
|
|
|
December 20th, 2009 09:06 PM
by JT
|
14 |
195 |
|
|
converting an .xlsm file to .xml? by
Janis
how do you save an .xlsm file as .xml?
the excel files are simple files with cells with no calculations.
the records are county property records with some...
|
|
1 |
195 |
|
|
|
|
5 |
195 |
|
|
|
April 1st, 2010 11:50 PM
by jj
|
8 |
195 |
|
|
Array Formula Help Needed by
nelly
Hi Guys
I need an array formula which counts the number of instances range Comp1 has
a value greater then zero AND Range Comp2 has a blank value.
Sounds...
|
April 13th, 2010 12:43 PM
by nelly
|
5 |
195 |
|
|
|
April 19th, 2010 05:19 PM
by Pete_UK
|
2 |
195 |
|
|
Formula Excel by
Newfie809
Wondering if someone would be able to help me with this:
A B C
Year Year Service
01-Sep-89 30-Jun-10 = 21 Years
Teachers
From September 1, 1989 to...
|
|
2 |
195 |
|
|
|
April 27th, 2010 07:35 PM
by Yannig
|
1 |
195 |
|
|
Column by
Alan
Apologies if there is a really obvious answer to this but it is driving me
mad! When you use the column() function you get the number of the column
(i.e....
|
|
4 |
195 |
|
|
Monthly files by
dimitry scharff
I have a monthly files where every day is a sheet, the beginning of which
references a cell on the sheet before. Is there a way of having this done
without...
|
|
2 |
195 |
|
|
LOOKUP or IF-THEN stmt - which one? by
JessP27
First, I apologize for the vague Subject, but I'm not sure what I need here....
I need to have a formula to look at two values and determine the result
based...
|
|
8 |
195 |
|
|
|
June 8th, 2009 04:22 PM
by Neall
|
9 |
195 |
|
|
|
|
9 |
195 |
|
|
Concatenate range (without UDF) by
Greg Lovern
Is it possible to concatenate a range using only Excel's built-in
worksheet functions?
Yes, I know it can be done in a UDF, and I can do that. I'm...
|
September 17th, 2009 05:36 PM
by T. Valko
|
6 |
195 |
|
|
lookup time value by
GAIDEN
I'm trying to lookup the time value 4:05:00 PM or the next highest time value.
I have:
B19 = 4:05:00 PM C19 = VLOOKUP(B19,D:D,1) D25 = 4:05:13 PM
D26 =...
|
|
3 |
195 |
|
|
|
September 24th, 2009 03:17 AM
by hejnoid
|
2 |
195 |
|
|
Multiple IF/AND/OR statments by
Zakynthos
What would be the format of the IF/AND/OR nested statement to return the
following:
If R1 contains a 9 and S1 contains a 36 I want a 4 in T1
If R1 contains...
( 1 2)
|
|
12 |
195 |
|
|
Conditional formatting on autoshapes by
Freshman
Dear experts,
Jacob Skaria, MVP wrote me a marco below for the solution of conditional
formatting on autoshapes. As Jacob's macro refers the value of A1 to...
( 1 2)
|
|
11 |
195 |
|
|
|
April 29th, 2010 04:25 PM
by UKMAN
|
4 |
195 |