Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
comparing column data and add if not present
I have the following data:
Order Group 1 Group 2 Group 2 Group 2 |Target1 Target2 782187 PRT |EQP 782679 BPR | BPR 783014 EQP PRT |EQP 783016 EQP PRT |EQP I would like to check each line and where group1 has a value, check to see if that value is in the target columns; it could be target1, 2, 3, 4. If it does exist then do nothing. If it doesn't exist then bring it over into ONE of the empty columns under either group 1-5 BUT it must not over write an existing value and it must have a unique value. So the output for this example would be. Order Group 1 Group 2 Group 2 Group 2 |Target1 Target2 782187 PRT EQP |EQP 782679 BPR | BPR 783014 EQP PRT |EQP 783016 EQP PRT |EQP You noticed I only added "EQP to the top line, the others were OK, because it already had the within the set. I have a few idea's brewing but I thought I would give the experts a shout to see who finishes first - smile. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing YTD numbers between last year and present | Excel Worksheet Functions | |||
Create a new row when data present in a column | Excel Discussion (Misc queries) | |||
need formula to return data from one column after comparing 2 othe | Excel Worksheet Functions | |||
Need to parse column data only when text is present | Excel Worksheet Functions | |||
SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions |