How can I set up the first column to automatically number each row as I go
down a list in excel?
Office 2000
How can I set up the first column to automatically number each row as I go
down a list in excel?
Office 2000
Assuming the data will be entered in column B starting in B1 and the data
are numbers. Put this in cell A1 and copy down.
=IF(ISNUMBER(B1),ROW(),"")
If data are text then substatute ISTEXT for ISNUMBER
Don Pistulka
"Linda C." <Linda [email protected]> wrote in message
news:[email protected]...
> How can I set up the first column to automatically number each row as I go
> down a list in excel?
> Office 2000
Assuming the data will be entered in column B starting in B1 and the data
are numbers. Put this in cell A1 and copy down.
=IF(ISNUMBER(B1),ROW(),"")
If data are text then substatute ISTEXT for ISNUMBER
Don Pistulka
"Linda C." <Linda [email protected]> wrote in message
news:[email protected]...
> How can I set up the first column to automatically number each row as I go
> down a list in excel?
> Office 2000
Assuming the data will be entered in column B starting in B1 and the data
are numbers. Put this in cell A1 and copy down.
=IF(ISNUMBER(B1),ROW(),"")
If data are text then substatute ISTEXT for ISNUMBER
Don Pistulka
"Linda C." <Linda [email protected]> wrote in message
news:[email protected]...
> How can I set up the first column to automatically number each row as I go
> down a list in excel?
> Office 2000
Assuming the data will be entered in column B starting in B1 and the data
are numbers. Put this in cell A1 and copy down.
=IF(ISNUMBER(B1),ROW(),"")
If data are text then substatute ISTEXT for ISNUMBER
Don Pistulka
"Linda C." <Linda [email protected]> wrote in message
news:[email protected]...
> How can I set up the first column to automatically number each row as I go
> down a list in excel?
> Office 2000
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks