Help with clusters

I want to create 200 clusters of data from a list of cells.

In my case, i have 1900 rows of data and i want to divide them in 200 equal groups.

How can i do that?

There should be 9 or 10 rows in every group.

What i need is a cell indicating me in what group number a certain row is.

 

So i should look something like this

1

1

1

1

1

1

1

1

1

1

2

2

2

2

2

2

2

2

2

ecc… until 200 groups on 1900 rows

By: Daniel

Leave a Reply

Your email address will not be published. Required fields are marked *