View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
muggeschiss muggeschiss is offline
external usenet poster
 
Posts: 3
Default how to sort column with cell pairs

sorry, vezerid's suggestion works too, of course. just had some problems with
"," and ";" due to my non-us country settings.
thanks!

"vezerid" wrote:

In B1:
=A1
In B2:
=IF(MOD(ROW()-ROW($A$1)+1,2)=1,A2,A1)