Alphabetize By Names of Data Ranges

[joey1745]

Hello all.

Recently I made huge sheet containing video games that I want to beat. Some of the games are part of a series, for example the Asssassin's Creed collection has Assassin's Creed two, three, four, revelations, brotherhood etc. I know how to name this data range, however I want to alphabetize the sheet by data range names. There are some rows that are only one game so I could either manually make it a data range or sort it by the name in column a. However, if i create a data range, i do not want to sort the individual rows in that range, and i want to keep them as a group. here is an example

Among Us
Amnesia
Assassin's Creed II
Assassin's Creed III
Assassin's Creed Chronicles
Bioshock

I want to name the assassin's creed groups by the data range name "Assassin's Creed" and sort by it while keeping the I II and chronicles in order (i.e not alphabetizing chronicles to the top) i'm not sure how to lock this range to be unaffected by sorting. I think it's an easy formula but i just don't know it

[Croweater]

You could extract the first two words of the title in another column and sort on that?

eg if your titles are in column A in B1 use this formula (drag down) and sort on column B.

=TRIM(LEFT(A1, FIND("^",SUBSTITUTE(A1, " ", "^",2)&"^")))

[joey1745]

I'm not really sure what you mean as I am fairly new to excel. However, I believe I have a different way to do it, although I'm not sure how. I can group certain games into one named range, is there a way to sort a column alphabetically based on using the names of the ranges?

[joey1745]

Actually (lol), I have a third way. I can manually sort the ranges into those, but once I have the ranges with the correct rows in order, is there a way to freeze these rows into place so I can move them as a group.

[joey1745]

Wait i get ur message ur a genius