View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How can I auto number rows only when data is entered in the same r

You could use a formula in column A that makes it look like an empty row until
something appears in column B. But you'll have to copy it down the column as
far as you need:

=if(b1="","",row())

(This assumes that no rows in column B are skipped.)

Plateav wrote:

I'm working with Microsoft Office 2003. Is there anyway I can auto number
rows (in sequence) in column A ONLY when data is entered in column B? 9 cool
points for the first correct answer. THANKS! (0:


--

Dave Peterson