'OFFSET Unique Name Manager
| Company | Client Name |
|---|---|
| Alpha | James |
| Alpha | Andrew |
| Bravo | Phyl |
| Charles | Bryan |
Total number of rows given = 4 in cell (TotalRows)
If I would like to create a name manager that provides dynamic search for Company, it will be =OFFSET(ClientDB!$A$2,0,0,TotalRows,1)
However, how do I provide distinct unique results for Company (E.g. Only Alpha, Bravo,Charles and not Alpha, Alpha, Bravo, Charles)? I tried =UNIQUE(OFFSET(ClientDB!$A$2,0,0,TotalRows,1)) but failed to work.
Also for Name Manager for Client Name how do I provide the same dynamic formula such that when Company Name is selected, it will show the corresponding Client Name? I will require this Name Manager as the rowSource for the VBA userform.
Thank you!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|