View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default how to sort column with cell pairs

use a helper column (B?)
ib B1 enter = A1
in b2 enter =A1 & "-1"
copy down as far as you want
select both columns and sort by column B

"muggeschiss" wrote:

hi
i need to sort a column with cell pairs, i.e. there is always a top cell
(name) and a bottom cell (data) which need to stay together. the sorting
should only consider the top cell.

A1: name1
A2: dataxdataxdatax
A3: name2
A4: dataydataydatay

any suggestions?