Hi,

I currently have a spreadsheet that contains a list of new joiners to my company with any outstanding tasks that need to be completed before they can join. This contains any person who has joined the firm up to 30 days in the past all the way to those joining 90 days in the future.

Each outstanding task has it's own row, so each Joiner can have several rows, depending on what is outstanding (if a task is completed it will not appear in the view.) The spreadsheet currently stands at about 6000 rows but this can vary somewhat (up to about 8000.)

What I want to do is to produce a summary view that will show a table with Joiners names on the rows and every possible task in the columns, then to show all of the names that are joining the company in a given period (most likely five days) along with flags to show which tasks have been completed or not.

I imagine I will need some kind of array formula to get this to work but I'm a little out of practise, if someone could get me started that would be a great help.

Any questions let me know

Thanks

Jon