View Single Post
  #1   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

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?