This is a straightforward request that reveals something important about how we think about spreadsheets. The user, jimmyjamcake, has 2,500 rows and wants to number them sequentially based on a column's value, John gets 1 through 4, Kyle gets 1 through 5, and so on. It is a simple, practical need. And in a traditional spreadsheet, the answer is a formula that works but feels like a workaround. You write something like `=COUNTIF($B$1:B1, B1)` and drag it down. It works. But it also exposes the gap between what the tool can do and what the user actually wants to express.
What jimmyjamcake is really asking for is a system that understands groupings. They do not want to number rows manually, and they do not want to write a formula that feels like a puzzle. They want to say, "Group by this column, then number each group from 1." That is a natural human instruction. The fact that it requires a forum post and a nested formula to accomplish is not a failure of the user. It is a failure of the tool to meet them where they are. Legacy spreadsheets treat data as a grid of cells, not as a collection of related records. When you have to write a workaround for something as basic as "number each group," you are spending mental energy on the tool, not on the problem.
This is where an AI-native approach changes the equation. Instead of asking the user to translate their intent into a formula, the tool can interpret the intent directly. "Number the rows in column A starting over for each unique value in column B." That is a sentence, not a function. The spreadsheet should understand it, execute it, and get out of the way. The user should not have to become a part-time programmer to manage 2,500 rows of names. They should be able to focus on what the data means, not on how to manipulate the grid.
Our opinion is plain: a spreadsheet that requires a workaround for grouping and numbering is not keeping pace with how people actually work. The solution exists in the shift from manual formulas to conversational commands. When you can simply describe what you need, the tool becomes an assistant rather than an obstacle. For jimmyjamcake, and for anyone managing thousands of rows of data, the real takeaway is this: do not settle for a tool that makes you think like a formula writer. Demand one that thinks like a collaborator.