Simple Question

W

WordProc

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
 
T

tjtjjtjt

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.
 
P

Patricia Shannon

If you look for "sequence" in Excel help, you will find
"About filling in data based on adjacent cells"
If you fill in the first 3 cells with 1 2 3, they select these cells, then
if you drag the handle at the bottom right corner down, it will fill in the
series. If you stop and need to continue the series, select the last 3 cells
and drag. The help also tells how to fill in a series using the menu
edit/fill/series.
 
P

Pete_UK

Using any column for the sequence, enter this formula in the first cell
(eg A1):

=ROW()

Copy this down as many rows as you need.

Hope this helps.

Pete
 
Top