JRI Poland #Poland RE: Sorting the data #poland
Jim & Sara Feldman <feldmans@...>
Ada:
The answer I am about to give assumes that the records are intermixed. That is, that M records are mixed with B and D records and that there are separate columns for GROOM and BRIDE name. That being the case, consider (and this is not the only solution): First sort the list on the column containing M/B/D. Do it in reverse order so that M comes out on top. (You could now simply copy it to another spreadsheet to simplify your life but I am doing it one sheet.) Now highlight the entire section containing M records and the headings as well. Excel allows you to sort in order by three different parameters (columns) so: Sort now FIRST on GROOM and SECOND on BRIDE. You have what you asked for. Jim Dear JRIERS,Jim Feldman 14 Linda Lane Newton, MA 02461 617-527-0509
|
|