On May 31, 2:49 pm, 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?

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

Select both rows and sort by B:B

HTH
Kostis Vezerides