How do I compare similar rows of data in same worksheet
 

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 ?

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 ?

Myrna do you have an example ? If I replace the "M" or "Dist" or any other
alpha showing ? How will it pull into a pivot table without counting or
summing the information ? I am pretty new at Pivot Tables. Thank you

"Myrna Larson" wrote:

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 ?