View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mcsmith1x
 
Posts: n/a
Default An If/Then Sort?

Recently converted all data from an old program to Excel list of ex-students
for a reunion. New request is to sort by Maiden name for the women, and Last
Name for the men for the book. First sort - YearGrad; Second Sort - either
maiden or last name. Can I somehow say sort by maiden unless blank, then sort
by last name?
--
Working Mom (redundant wording)