reighzaigne
New Member
- Joined
- Oct 19, 2015
- Messages
- 28
Hi all,
I am working on a database of suppliers which basically looks like this:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
So basically, in another sheet, I wanted to get the unique names from "HMUA" and then "Gowns" on separate columns. The original file will have "-" characters and a lot of blank cells.
I would also want to exclude the "-" from the unique list if possible.
If it's also possible to have a formula that extracts the list alphabetically? but it's not required.
Please share formulas only as I don't know how to do VBA.
I am working on a database of suppliers which basically looks like this:
Client | HMUA | Gown |
1 | A | W |
2 | A | R |
3 | D | S |
4 | C | Q |
5 | B | W |
6 | - | - |
7 | D | |
8 | ||
9 | C | Q |
10 | - | - |
11 | D | S |
12 | W | |
13 | A | R |
14 | D | R |
15 | B | W |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
So basically, in another sheet, I wanted to get the unique names from "HMUA" and then "Gowns" on separate columns. The original file will have "-" characters and a lot of blank cells.
I would also want to exclude the "-" from the unique list if possible.
If it's also possible to have a formula that extracts the list alphabetically? but it's not required.
Please share formulas only as I don't know how to do VBA.