Hi everyone, i'm struggling to sort in Excel. I have a labelled data from 1-5. What i want is the data sorted with repeated number. To help you visualize see the picture below. Is there any way to resolve this? Thank you
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to repeating sort in excel
- Thread starter ingkafi
- Start date
-
- Tags
- sort sort alphabetical
Excel Facts
Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
JamesCanale
Well-known Member
- Joined
- Jan 13, 2021
- Messages
- 1,186
- Office Version
- 365
- Platform
- Windows
I can't get strange spreadsheets over here.
Upvote
0
Similar threads
