This is my daughters book list. Column A is the author, Column B is the Book title. The ones that are colored in column b are sequels. The numbers in parenthesis are the order of the sequel.
What I am trying to do is sort alphabetically by author, and keep the books in column b together with the author. I have worked on this for two hours and I'm skunked. If someone could help us we'd really appreciate it! I am using Excel 2003 and she is using 2013. Sample sort worksheet.xls
i dont think you can do that with a sort - as the column A needs to have the author repeated in the same row as the titles
it maybe possible with some form of VBA - but not my expertise
you would need to copy the author down for each of the title rows
and then you can sort by A with a SUB-Sort by B
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
first put all the school books in column b instead of column a
then in c2 put
=IF(A2="",C1,A2)
fill down
sort everything by column C
note the authors will be sorted by first name if you want to sort by last name you will have to split them up first
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I don't understand. The books are in column b already. Did you mean that I should move the author to column b also?
no they are not ,school books are all in column A listed below the heading in a492:a537
If you highlight the list of books for the author and click sort you will get a warning box. Mark Continue with the current selection. You then get your sort box and by default you should have sort by Column B/ Sort on Values/Order A to Z. You will have to repeat that for all 77 authors but it worked for me.
Here is something to try.
FIRST Move the book titles from A490 to A537 to column B
Select column A from A2 to A580
Click on Find & Select, Go to Special, Blanks, click OK
Type the = sign then hit the up arrow followed by Ctrl + Enter
Click on COPY
Click on Paste, Values......This might be Paste Special, Values.
Now you should be able to select all the data and sort by the author keeping the books with the author.
Last edited by newdoverman; 11-10-2014 at 06:01 PM.
<---------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
Thanks, etaf. That worked great. Sorry it took so long to respond. I appreciate your quick response.
your welcome ,thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks