Hi All,
I'm looking to get a list of values based off of information in another column. See the fictitious table below. In the first column are sequential order #'s and in the second column are the clients' names.
I'd like to pull the list of values in column A based on the client in column B.
<tbody>
</tbody>
Thank you!
I'm looking to get a list of values based off of information in another column. See the fictitious table below. In the first column are sequential order #'s and in the second column are the clients' names.
I'd like to pull the list of values in column A based on the client in column B.
Order # | Client |
HDS17-1 | CLIENT2 |
HDS17-2 | CLIENT1 |
HDS17-3 | CLIENT2 |
HDS17-4 | CLIENT2 |
HDS17-5 | CLIENT1 |
HDS17-6 | CLIENT1 |
HDS17-7 | CLIENT1 |
HDS17-8 | CLIENT2 |
<tbody>
</tbody>
Thank you!