Send to a Friend

wildpotato's avatar

How can I alphanumerically sort data in Excel with an exception?

Asked by wildpotato (15224points) October 28th, 2010

I really hope someone can help with this – it would make my work life so much easier. First of all, check out this photo (my first time using photobucket, so someone please let me know if it doesn’t work!).

I want to sort Column B by those initials you see there – LS, CH, SH, CJ. But I can’t just do that because Excel will count the cells where it says “PT” as well as the initials as data to be sorted. I can’t let it do that, because I need the rest of the info in the row where the “PT” cell is located to stay where it is in relation to the info in the rows under that row, down until the row where it reads “Total” in one of the cells.

So I need to tell Excel to ignore the “PT” cell in its sort of the rest of the data in that column, while still keeping each header row attached to the data in the few rows underneath. Is this even possible? I have been told that there is a formula which allows for exceptions in sorting, but I am having trouble Googling for it. Are there any Excel experts out there who wouldn’t mind taking a stab at it?

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.