or worse in excel, if they try to sort and don't select all the columns, they mix-n-match data .. e.g. everyone's name or address or something gets jumbled w.r.t their id..


I was given a pile of shi^H^H^Hdata once where the name could be any of the following (sal==Salutation):

First Last
Last First
Last, First
F Last
Sal Last
Sal First Last
Last, Sal
Last Sal
[download]

We just printed it and had someone visually match up with the ids.