bearcub
Well-known Member
- Joined
- May 18, 2005
- Messages
- 701
- Office Version
- 365
- 2013
- 2010
- 2007
- Platform
- Windows
I have a table that has all the details for a commissions paid to our sales teams (~ 14 Columns).
I would like to create a unique dynamic list on another sheet that is based on the this source but I only want to extract 3 columns of data (Customer Name, Earning Group and USD amount) from the source data.
How would I create a unique list by using the Unique array function?
I would like to create a unique dynamic list on another sheet that is based on the this source but I only want to extract 3 columns of data (Customer Name, Earning Group and USD amount) from the source data.
How would I create a unique list by using the Unique array function?