Creating segregated lists based on value in column

[theThirdMan]

Basically looking for the best way to create lists based on criteria in a column, e.g.:

Sheet1:

Task Person Status
task1 Person1 Finished
task2 Person2 Finished
task3 Person2 Pending
task4 Person1 Pending


Sheet2 (or word document):

Finished tasks:

Person1 - task1
person2 - task2

Pending tasks:

person2 - task3
person1 - task4



Been a while since I messed around with if statements, but I think I can manage that part. Can't seem to figure out how I'll be able to be able to add rows though? If there are any VBA samples available, I could probably reverse engineer to fit my needs, despite being unable to write code myself. This will be a recurring "report" and need to be "run" on a periodic basis/printed to a memo.

Thanks in advance.

[José Augusto]

For your office version

Try this array formula with data in A2:C6 (row 2 is header) and F8 is Pending or finished

In E9:

Please Login or Register  to view this content.

Note:confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

For newer version (2010 or more recent)

Try this normal formula in E3 (F2 is is Pending or finished

Please Login or Register  to view this content.

See the file

[theThirdMan]

Ultimately the report will include all statuses in a single column. Therefore I assume that's why maybe VBA may be necessary to some extent automatically generate rows, so there aren't empty rows underneath each section. Thanks for the above though, if I am unable to figure it out, that may need to suffice in the interim.

Thanks.