duplicate fields

[Lenny]

Is there a way to write a formula to examine the preceding row and if the value is the same, leave the cell blank. For Example:

Column A
2
2
2
2
2
2
9
9
9
9
What I want it to do is this:
Column A
2





9

[Nobby]

Assuming your data in ColA starts at A2, eneter the follwoing formula in B2

=IF(A2=A1,"",A2)

then paste down your column.

Nobby

[Aladin Akyurek]

supposing that the first item is in A2,

enter in B2

=IF(COUNTIF($B$1:B1,A2),"",A2)

and copy down.

[Lenny]

Thanks for the info but is there any way to keep the data in Column A. I put your formula in colA and keep getting a circular reference error.

Thanks

[Aladin Akyurek]

On 2002-05-15 00:48, Lenny wrote:
Thanks for the info but is there any way to keep the data in Column A. I put your formula in colA and keep getting a circular reference error.

Thanks

No, not with formulas.

You'll need VBA code to do it in the same column.