I have a worksheet that could have mulitple rows of data for an individual I
need to combine to onerow based on status.

Example:
1 Name AK AL AR CA
2 MSMITH 0 DIST M 1
3 MSMITH 1 0 0 1

If MSMITH has a "1" in either row pull this into row 2, if not = 1 pull "0",
"M",or "DIST" into row 2. What would be the formaula to have Excel look at
the name column see if there is multiple matches for thename row and then
look at status of the AK, AL, AR, CA, ... columns ?