How do I sort multiple columns alphabetically with the last name first, then the first name as the 2nd sorting option?
Here is an example of what I have:
year; first; last
2011 chris Bell
2010 chris Bell
2009 chris Bell
2008 chris Bell
2007 chris Bell
2006 chris Bell
08-11 chris Bell
06-11 chris Bell
02-11 chris Bell
2012 roger Bell
2011 roger Bell
2010 roger Bell
2009 roger Bell
2008 roger Bell
2007 roger Bell
2006 roger Bell
2005 roger Bell
2004 roger Bell
2003 roger Bell
2002 roger Bell
08-11 roger Bell
06-11 roger Bell
02-11 roger Bell
2006 n chris Bell
2002 n chris Bell
2006 n roger Bell
2005 n roger Bell
2004 n roger Bell
2003 n roger Bell
2002 n roger Bell
2001 n roger Bell
2004 trey Bell
2004 n trey Bell
02-11 trey Bell
As you can see, the first names aren't sorted 100% alphabetically. I think issue stems from the years 2001 n-2006 n. I have to use the 2001 n since its a different data than the normal 2001.
The default sorting was by year:
2012
2011
2010
2009
...
2006
2006 n
2005
2005 n
...
2001 n
08-11
06-11
02-11
So I want it to sort by last first, then first name. Then it should sort by the default sort I already had in the left column (years)
I have multiple last names for each year. Right now
Bookmarks