Excel series numbers

[Guest]

Please help I need to give a number of records unique numbers for an import
reference. Normally this wouldn't be a problem as I would just drag and fill
a column with the numbers, but this time I need to go from left to right and
then down and I can't drag and fill - does anyone know a formula that creates
a series of unique numbers?

 

[Joseph Meehan]

Please help I need to give a number of records unique numbers for an
import reference. Normally this wouldn't be a problem as I would just
drag and fill a column with the numbers, but this time I need to go
from left to right and then down and I can't drag and fill - does
anyone know a formula that creates a series of unique numbers?

Are you exporting to Access?

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.

Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.

 

[John Vinson]

Please help I need to give a number of records unique numbers for an import
reference. Normally this wouldn't be a problem as I would just drag and fill
a column with the numbers, but this time I need to go from left to right and
then down and I can't drag and fill - does anyone know a formula that creates
a series of unique numbers?

You might want to ask this question in one of the Excel newsgroups;
this newsgroup is for a different program, Microsoft Access.

John W. Vinson[MVP]