Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting and filtering
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? |
#2
|
|||
|
|||
You can use an Advanced Filter to create a unique list from the selected
column. There are instructions in Excel's Help, and he 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should allow sorting and filtering based on cell color. | Excel Worksheet Functions | |||
HELP! Filtering and sorting lists. | Excel Worksheet Functions | |||
Sorting and filtering | Excel Worksheet Functions |