•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?
Our take
If you're looking to efficiently number rows in a spreadsheet based on the values in another column, you've come to the right place. With a dataset of 2,500 rows, manually numbering can be tedious and time-consuming. Fortunately, there are straightforward methods to automate this process, allowing you to create a numbered list that adapts to the entries of your chosen column. Let's explore how to streamline this task, enhancing your productivity and making your data management experience smoother and more intuitive.
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!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience