Hi,
I want to extract all the unique values from column A starting with A2 to the last cell of column A that has a value and copy those values into cell B2 all the way down to whatever the last cell of column B is.
I have row titles in cells A1 and B1.
Example:
Data Before Macro:
<colgroup><col style="mso-width-source:userset;mso-width-alt:4096;width:84pt" width="112"> <col style="mso-width-source:userset;mso-width-alt:5997;width:123pt" width="164"> <col style="mso-width-source:userset;mso-width-alt:4973;width:102pt" width="136"> </colgroup><tbody>
</tbody>
Data After Macro:
<colgroup><col style="mso-width-source:userset;mso-width-alt:4864;width:100pt" width="133"> <col style="mso-width-source:userset;mso-width-alt:4571;width:94pt" width="125"> <col style="mso-width-source:userset;mso-width-alt:5120;width:105pt" width="140"> </colgroup><tbody>
</tbody>
Thanks,
BC
I want to extract all the unique values from column A starting with A2 to the last cell of column A that has a value and copy those values into cell B2 all the way down to whatever the last cell of column B is.
I have row titles in cells A1 and B1.
Example:
Data Before Macro:
Column A | Column B | |
Row 1 | All Codes | Distinct Codes |
Row 2 | 456 | |
Row 3 | 456 | |
Row 4 | 678 | |
Row 5 | 678 | |
Row 6 | 890 | |
Row 7 | 543 | |
Row 8 | 543 | |
Row 9 | 234 | |
Row 10 | 213 | |
Row 11 | 905 | |
Row 12 | 905 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:4096;width:84pt" width="112"> <col style="mso-width-source:userset;mso-width-alt:5997;width:123pt" width="164"> <col style="mso-width-source:userset;mso-width-alt:4973;width:102pt" width="136"> </colgroup><tbody>
</tbody>
Data After Macro:
Column A | Column B | |
Row 1 | All Codes | Distinct Codes |
Row 2 | 456 | 456 |
Row 3 | 456 | 678 |
Row 4 | 678 | 890 |
Row 5 | 678 | 543 |
Row 6 | 890 | 234 |
Row 7 | 543 | 213 |
Row 8 | 543 | 905 |
Row 9 | 234 | |
Row 10 | 213 | |
Row 11 | 905 | |
Row 12 | 905 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:4864;width:100pt" width="133"> <col style="mso-width-source:userset;mso-width-alt:4571;width:94pt" width="125"> <col style="mso-width-source:userset;mso-width-alt:5120;width:105pt" width="140"> </colgroup><tbody>
</tbody>
Thanks,
BC