Lookup Tables

[Darrell]

I am trying to create a worksheet that will show a list
of tasks that need to be completed down the columns(1-50)
and a list of staff across the top(A-H) and then have a
tick or cross against each cell to signify that the person
has completed the task(or not).

My problem is that I cannot find a way to tell excel that
I want to see the ticks and crosses for either
a): a specific person
b): a group of people (department name like Accounts Dept)
c): all the names

I have looked a pivot tables and vlookup but am going
around in circles.

Can anybody help me on this?

Many Thanks

Darrell
WSM/UK

 

[Andy B]

Hi

Maybe AutoFilter is what you are looking for. Try Data / Filter / AutoFilter
and you can filter the data by any value in any column.

Hope this helps.