View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default Alternating sort question


The most difficult solution is usually the first one to come to mind.
That's the way it works for me. <g
Jim Cone


"Gord Dibben"
wrote in message
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,
"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.