Thread: Simple Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tjtjjtjt
 
Posts: n/a
Default Simple Question

I think I've seen something like this on the message board to create a counter.
=IF(B3="","",COUNTA($B$3:B3))
This assumes that the list starts in Row 3. Enter the formula in A3 and
copy down for all records.
Make sure that you have information in Column B for each record, or that
record won't get counted.
--
tj


"WordProc" wrote:

Hello!
I would like to have a column in my spreadsheet that just gives a sequential
number for each record. Just a counter.

Any help you could give me would be wonderful!

Thanks so much!
-Lynne