cgendron
Board Regular
- Joined
- Apr 13, 2011
- Messages
- 111
Hey all,
I have two columns, A and B. Column A has certain words pertaining to codes, column B has the codes.
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
I'm using a vlookup to find any code with the word "deleted" next to it. The obvious problem i have is it only bring in the first instance. How do i ignore the duplicates and only bring in the unique code instance? i have a summary column for all the deleted and added ones. I want all the deleted codes under the deleted column and added codes under the added column.
<colgroup><col><col></colgroup><tbody>
</tbody>
Thanks in advance!
I have two columns, A and B. Column A has certain words pertaining to codes, column B has the codes.
Change | Code |
Deleted | 10021 |
Added | 10022 |
10060 | |
Deleted | 10061 |
10120 | |
10140 | |
Deleted | 10180 |
11055 | |
11100 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
I'm using a vlookup to find any code with the word "deleted" next to it. The obvious problem i have is it only bring in the first instance. How do i ignore the duplicates and only bring in the unique code instance? i have a summary column for all the deleted and added ones. I want all the deleted codes under the deleted column and added codes under the added column.
Deleted | Added |
J1725 | 90651 |
J1725 | |
J1725 | |
J1725 | |
J1725 | |
J1725 | |
J1725 | |
<colgroup><col><col></colgroup><tbody>
</tbody>
Thanks in advance!