Thread
:
how to sort column with cell pairs
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
muggeschiss
external usenet poster
Posts: 3
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)
Reply With Quote
muggeschiss
View Public Profile
Find all posts by muggeschiss