View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Alternating sort question

I knew there was an easier way<g

Assign same numbers after filtering, not odds and evens.


Gord

On Sun, 27 Apr 2008 12:41:17 -0700, "Jim Cone"
wrote:

In an adjoining column, consecutively number the male students... say 1 thru 20
and then assign the same numbers to the female students... 1 thru 20.