Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine and Compare Data
I have columns of data as follow and I need to generate a radar chart:
Col A - Plant Name Col B - 1st Party Test Col C - 2nd Party Test Sometimes there are duplicates in Col A because it has data in Col B and Col C but not always. Is there a way to remove the duplicate plant name from Col A and then move the data from Col C for that row to the appropriate row in Col A? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare two sheets and combine into one | Excel Worksheet Functions | |||
Compare then combine data, then mailmerge with Word | Excel Discussion (Misc queries) | |||
compare and combine data with in one workbook | Excel Worksheet Functions | |||
How do I activate the xls feature to combine and compare workbooks | Setting up and Configuration of Excel | |||
Compare two Workbooks and combine data into one workbook | Excel Programming |