Mgiyuk

Increment a counter every ten rows I have an Excel spreadsheet with more than 50,000 rows and want to add a column that effectively groups the data in sets of ten by assigning an increasing number to every ten rows heading downwards. To clarify, this is what I'm going for: Col A Col B Decile 1 * * 1 2 * * 1 3 * * 1 4 * * 1 5 * * 1 6 * * 1 7 * * 1 8 * * 1 9 * * 1 10 * * 1 11 * * 2 12 * * 2 13 * * 2 14 * * 2 ... 199 * * 19 200 * * 19 201 * * 20 ... The current way I have of doing this is to insert this function into the first entry of the Decile column and copy it down to the whole column: =INT(COUNTA($A1:A$2)/10) + 1 which counts all the rows from A2 to the current row, divides by 10,...