Thread: Sort
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Sort

Hello,

Same as before but enter into E2:
=IF(C2<"",IF(ISERROR(LOOKUP(2,1/(C$1:C1=C2),E$1:E1)),MATCH(C2,$A$1:$A
$20000,0),LOOKUP(2,1/(C$1:C1=C2),E$1:E1)+MATCH(C2,INDEX($A
$1:$A19997,1+LOOKUP(2,1/(C$1:C1=C2),E$1:E1)):$A$20000,0)),"")
and copy down.

E1 stays as I mentioned before!

Regards,
Bernd