Allocating numbers 1-10 to rows in table

[#1]

Hello,

I have a (suposedly) very simple problem, however, I have been sitting for hours to figure this out and haven't found any help in prior topics.

I have a table with ~200-300k rows that is concatenated and joined from many other tables. And in this loaded table I need to assign numbers 1-10 to each row (each number represents an owner), they should probably be assigned in a continous form (1....3....10...1......4...5...etc), so that each owner gets equal number of rows.

Example

Client,     Product,     Owner

John,     xxxx,     1

Mark,     yyyy,     2

Kate,     zzzz,     3

.....

Elviss,     oooo,     10

Chuck,     pppp,     1

etc.

Please help It should be done in the table, because, the output data needs to be equally asigned to owners even if filters are changed.

[swuehl · Accepted solution]

Are you looking for something like

=mod(rowno(TOTAL)-1,10)+1

?

[#3]

I new it should be simple, too bad I didn't know this function.

Thanks' a lot!!