I knew Excell would have that sussed, I also suspected that my
successful lobotomy would hamper my understanding. Still you never
know I may be able to work it out.

A Genuine Thanks (I think)


On Tue, 11 Apr 2006 07:29:16 -0500, John James
wrote:


Keep whatever keys you might wish to sort on in separate columns.

You can always calculate most full names in another column, rather than
having to re-enter e.g.
=A2&" "&B2

or if say columns A and C are always used but B and D are sometimes
used:
=A2&if(B2=""," "," "&B2&" ")&"C2"&if(D2="",""," "&D2)


You will then be able to sort however you want - e.g. by christian name
within surname, by full bandname, etc. It's likely you'll eventually
regret it if you don't store all usable fields separately.