IF statement questions
 

Excel 2000

I must have something set wrong. Three things may happen with this formula
in column C:

=IF(A1<A2,A1,"") - either the whole formula (including the =) appears in
the cell and does not increase cell #s when drawn down), or I get blanks -
even though A1 and A2 are different, or the contents of A1 is also put in
C2,C3,but the formula says =IF(A2<A3,A2,""). The contents of A are names
imported from another file. There is no ' in front of the name. Column A is
formatted as 'general'. The options show formula is not set.

What I want is a formula that will show the name on the first occurrence of
the name, and if it is repeated in succeeding cells, will not show the name.

TIA,
CaroleO

IF statement questions
 

1 If you're seeing the formula rather than its result, make sure that the
cell isn't formatted as text before you enter the formula. Reformat as
text, and re-enter the formula.
2 Tool/ Options/ Calculation: set to Automatic, not Manual.
--
David Biddulph

"Carole O" wrote in message
...
Excel 2000

I must have something set wrong. Three things may happen with this
formula
in column C:

=IF(A1<A2,A1,"") - either the whole formula (including the =) appears
in
the cell and does not increase cell #s when drawn down), or I get blanks -
even though A1 and A2 are different, or the contents of A1 is also put in
C2,C3,but the formula says =IF(A2<A3,A2,""). The contents of A are names
imported from another file. There is no ' in front of the name. Column A
is
formatted as 'general'. The options show formula is not set.

What I want is a formula that will show the name on the first occurrence
of
the name, and if it is repeated in succeeding cells, will not show the
name.

TIA,
CaroleO

IF statement questions
 

#2 was it!! Thanks, David

"David Biddulph" wrote:

1 If you're seeing the formula rather than its result, make sure that the
cell isn't formatted as text before you enter the formula. Reformat as
text, and re-enter the formula.
2 Tool/ Options/ Calculation: set to Automatic, not Manual.
--
David Biddulph

"Carole O" wrote in message
...
Excel 2000

I must have something set wrong. Three things may happen with this
formula
in column C:

=IF(A1<A2,A1,"") - either the whole formula (including the =) appears
in
the cell and does not increase cell #s when drawn down), or I get blanks -
even though A1 and A2 are different, or the contents of A1 is also put in
C2,C3,but the formula says =IF(A2<A3,A2,""). The contents of A are names
imported from another file. There is no ' in front of the name. Column A
is
formatted as 'general'. The options show formula is not set.

What I want is a formula that will show the name on the first occurrence
of
the name, and if it is repeated in succeeding cells, will not show the
name.

TIA,
CaroleO