View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jabberwocky Jabberwocky is offline
external usenet poster
 
Posts: 7
Default help: sorting rows by lesser value of two columns

sorry that wrapped funny. Perhaps this will be clearer:
Example:

* * * * * column A * * Column B

Row 1: * 1 2 ** * *<--lesser value is 1
Row 2: * 2 2* * * *<--Lesser value is 2
Row 3: * 4 4 * * *<--Lesser value is 4
Row 4: * 5 3 * * *<--Lesser value is 3

BECOMES:

* * * * * column A * * Column B

Row 1: * 1 * * * * * * * * 2
Row 2: * 2 * * * * * * * * 2
Row 3: * 5 * * * * * * * * 3
Row 4: * 4 * * * * * * * * 4