If you can replace the M and DIST with some numeric code, perhaps you could
use a Pivot Table for this.

On Sat, 19 Feb 2005 08:11:05 -0800, "JT" wrote:

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 ?