thanks pete. the sorting i need is alphabetical; that is to say when i sort a
large amount of data, i need the two rows containing related information to
remain related. are you able to give a formula i can use for this?
thanks in advance.
anyole
--
ino ne sauti ya anyole okhurula ebusikhale emmayoka. orakhaenda omwoyo tawe.
khuli halala. nyasaye akhulinde. embwo


"Pete_UK" wrote:

Were you thinking of sorting them on some other field (like name)?

You can introduce a simple sequence 1,2,3,4 etc down a helper column
and if you include this in your sort criteria then you can get the
rows to follow the sequence, though it would depend on the other sort
field (name) appearing in all cells down the column.

If your data is not like this then post back with further details of
how your data is laid out, and I'm sure someone will be able to
suggest a way forward.

Hope this helps.

Pete

On Jun 30, 5:22 pm, anyole wrote:
if one set of data record is on two rows, how do i sort it so that the rows
retain data relevant to the dataset? eg.

Albion Gate
Albion Street W2 2LA
Alcazar, The
Phoenix Street WC2H 8BS
Alcove
Napier Place W14 8LG
Alders, The
Aldrington Road SW16 1TP
Aldershaw
Watkinson Road N7 8EX
Aldgate Barrs
Whitechapel High Street E1 7PJ
Alfred Villas
Barrett Road E17 3NB

whe
Albion Gate
Albion Street W2 2LA

belong to the same data record.

Thanks a lot
anyole
--
ino ne sauti ya anyole okhurula ebusikhale emmayoka. orakhaenda omwoyo tawe.
khuli halala. nyasaye akhulinde. embwo