Yes, that's correct. There may be from 5 to 500 rows depending on the data
and I usually enter the formula in A2, then copy it and hold the Shift button
down and then the End Down buttons to highlight all Rows in Cols A & B down
to the bottom of the data in Col B. Then I hit the left Arrow key and only
Cells A2:B??? are highlighted. I then paste the formula to these cells.
It's sort of a Copy, Move Over Right, Move Down to Bottom of data in next
Column, then Back to original Column and Paste. Is this enough of a picture?
--
Mickey


"JGeniti" wrote:

I'm a little confused as to what you are trying to do.
Do you only want to add the formula in the "A" column if there is data
in the "B" column? Can you be a little more specific or maybe give a
visual?