March 19, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is there an easy way to number rows based on the value of another?

I've got a sheet with 2500 rows, can I quickly number the rows from 1-x based on another column?

Example

A B

1 john

2 john

3 john

4 john

1 kyle

2 kyle

3 kyle

4 kyle

5 kyle

Thanks for your help!

Check out the full article on the original site

#rows.com

#Excel alternatives for data analysis

#cloud-based spreadsheet applications

#natural language processing for spreadsheets

#generative AI for data analysis

#Excel compatibility

#financial modeling with spreadsheets

#Excel alternatives

#numbering

#rows

#sheet

#columns

#quickly

#data

#based on

#values

#example

#user

#reddit

#forum