sorting and filtering

You can use an Advanced Filter to create a unique list from the selected
column. There are instructions in Excel's Help, and here:

http://www.contextures.com/xladvfilter01.html

Duncan McDowell wrote:
> I want to source a single column from a separate worksheet named 'projects'
> and create a function that will return each project in another worksheet, but
> only once (many projects are listed multiple times). Can anybody lend a hand?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You can use an Advanced Filter to create a unique list from the selected
column. There are instructions in Excel's Help, and here:

http://www.contextures.com/xladvfilter01.html

Duncan McDowell wrote:
> I want to source a single column from a separate worksheet named 'projects'
> and create a function that will return each project in another worksheet, but
> only once (many projects are listed multiple times). Can anybody lend a hand?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I want to source a single column from a separate worksheet named 'projects'
and create a function that will return each project in another worksheet, but
only once (many projects are listed multiple times). Can anybody lend a hand?

You can use an Advanced Filter to create a unique list from the selected
column. There are instructions in Excel's Help, and here:

http://www.contextures.com/xladvfilter01.html

Duncan McDowell wrote:
> I want to source a single column from a separate worksheet named 'projects'
> and create a function that will return each project in another worksheet, but
> only once (many projects are listed multiple times). Can anybody lend a hand?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html