How to invert row selection in Excel & Can I sort on last letter of a text string?

Two questions:

1. I have selected certain full rows from my spreadsheet, and now I wish to invert that selection (i.e. I now want to select all the rows I didn't select in my first selection). How do I do that?

2. I would like to sort the rows in a selection based on the last letter in a text string. Each row has a cell containing a 7-letter text string ending in either a W or an M. I need to sort by W and M. How could i do this?

I can't answer your first question.

For your second question you could make use of a helper column with a formula like this:

=RIGHT(cell,1)

Copy that down, and then sort the data using the helper column as the key field, and then you can delete the helper column.

Hope this helps.

Pete

@jdouglasj, here is some vba code to handle your first question about inverting the the selection of rows:

Please Login or Register  to view this content.

As far as your 2nd question goes, which column contains the 7-letter text string?