Hi,
I have the below data, what I am trying to achive is to take column D, match it to column A (these will be unique in A) and everytime D matches A, paste C and E into a comment.
For example in the below, A3 would say 123 Ewer & 120 greg. A4 would say 456 fsdf, A10 would say 564 gsdd & 945 sdfsd.
Hopefully that makes sense (if it can't go into the comments, then into column B would do, but I'd like comments if possible)
<TBODY>
</TBODY>
I have the below data, what I am trying to achive is to take column D, match it to column A (these will be unique in A) and everytime D matches A, paste C and E into a comment.
For example in the below, A3 would say 123 Ewer & 120 greg. A4 would say 456 fsdf, A10 would say 564 gsdd & 945 sdfsd.
Hopefully that makes sense (if it can't go into the comments, then into column B would do, but I'd like comments if possible)
A | B | C | D | E | |
1 | |||||
2 | Master | Coded | IDS | Internal | |
3 | Apr1398750 | 123 | Apr1398750 | ewer | |
4 | Apr1398875 | 456 | Apr1398875 | fsdf | |
5 | Apr1399000 | 120 | Apr1398750 | greg | |
6 | Apr1399125 | 564 | Apr1399625 | gsdd | |
7 | Apr1399250 | 945 | Apr1399625 | sdfsd | |
8 | Apr1399375 | ||||
9 | Apr1399500 | ||||
10 | Apr1399625 |
<TBODY>
</TBODY>