Hi All,
i am trying to find a a function that can filter a column of supplier codes (the column will have the supplier code in it between 1-??? times) then return it on a new sheet just once along with the supplier description (adjacent cell) eg:
the source sheet
<tbody>
</tbody>
and the result i want is just the supplier listed once on a new sheet
<tbody>
</tbody>
i hope I have made that clear enough, if not please tell me.
i am trying to find a a function that can filter a column of supplier codes (the column will have the supplier code in it between 1-??? times) then return it on a new sheet just once along with the supplier description (adjacent cell) eg:
the source sheet
<tbody> </tbody> |
<tbody> </tbody> | |||
21330 | AshDown | |||
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> | Multispares | |||
<tbody> </tbody> | Multispares |
<tbody>
</tbody>
and the result i want is just the supplier listed once on a new sheet
<tbody> </tbody> | ABC People | |
21330 | AshDown | |
20717 | Multispares |
<tbody>
</tbody>
i hope I have made that clear enough, if not please tell me.