Occasional Visitor

if i want start numbers in cells .. start from number 1 to boundless.. or random numbers without repetiton in another cells like in cell number a1 start with number 1 in cell ..and in cell number a100 number is 100 or in cell number 1a start with 33546 and this number isn't repetiton in any cell .. what i must be type to do this 

1 Reply


If you are using an Excel Table, a field containing the formula

= ROW(Table1[@]) - ROW(Table1[#Headers])

will provide an ordered column of serial numbers.

Randomly assigned key numbers can be generated using the RANDARRAY function but the function is volatile and so the keys will be reassigned every time the workbook is opened or edited.  For example 

    SEQUENCE(1024, 1, 1024*31),