Excel Pivot Table Help

[IntoTheVoid]

Hi,

I have a spreadsheet with the following columns: Reference Number, Name, Date Assessment Last Completed Internally, Date Assessment Last Completed Externally.

In the date columns there are either dates or the text 'None' if an assessment has never been completed.

I need to summarise how many people have assessments that are over 12 months old or have never had an assessment. Assessment Internally or Externally count as acceptable.

Will a pivot table help me achieve this quickly? I am struggling at the moment to extract information using multiple filters which is not working well.

I am using Excel 2007 although at work we use Office 2003.

Advice appreciated. I do not know anything about how to use Pivot tables at present.

 

[namnoc]

I don't see why you need a pivot table, just do a conditional test on ( internal test date blank OR older than 12 months ) AND ( external test date blank OR older than 12 months )

That will give you all the people you are looking for.