Count/Lookup with added info

Hi,

the attached spreadsheet lists employee ID's, names, and begin and end date for absences as well as the reason for absence code and description.

Is there a way to put a new sheet in that references this information and lists the following:

1) all people with 3 or more instances of absence (no matter how long)
2) all people with 10 working (not calendar) days or greater of absence
2) the amount of days absence for each instance for those listed in '1)' and '2)'
3) list the associated reasons for each of the instance for those listed in '1)' and '2)'

Any help is much appreciated.
Thankyou

dan

Perhaps this is a start

regards

Dav

Thanks mate, that is useful and solves the task basically. Though being picky and an idealist i was hoping to be able to do it all via formulas and not pivots..would you know how to do that, if not this does work well enough so thanks.

It can be done via formulas, but you would have to provide a staff list, and if the tables were to self generate they would need VBA. It would be easier to sum against the staff list eg calaculate the number of days and occurances sick and the reasons for them. This could all be done with sumproduct functions, then I guess with a few arrays the tables could be populated. with formulas it would take a lot of formulas

I usually avoid pivot tables myself


Regards

Dav