| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing data in two similar worksheets | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
| Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Threaded Mode
