I have a list of data as follows
1.1.
1.1.1
1.1.1.1
1.1.1.2
1.1.1.3
1.1.1.3.1
1.1.1.3.1.1
1.1.2
1.1.2.1
------
What I want to do is be able to group at the 2nd level (e.g., 1.1.1 and 1.1.2) is there a faster way to do this rather than eyeballing my way down the data?
Your sample data sorts in the order that you want.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
=left(a1,6) and drag down.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Smart, thank you. I should have thought of thatOriginally Posted by oeldere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks