Forum Discussion
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 a10...
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
= SORTBY(
SEQUENCE(1024, 1, 1024*31),
RANDARRAY(1024)
)