I have a tracker for training and want to count how many records are out of date based on team and whether or not they are active. Column B says if Leaver, Column D has the team and column E - H have the records.
If column B is Blank (active record) then how many records in Column E are more than 11 months old (ie ready for annual refresher) then group the answers by team. a sample of the info is below, I couldn't attach an excel sample. I am creating tables and charts on a second tab.
Hope someone can help
[TABLE="width: 1386"]
<colgroup><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Leaver (X)[/TD]
[TD]Name[/TD]
[TD]Team[/TD]
[TD]Info[/TD]
[TD]Bias[/TD]
[TD]H&S[/TD]
[TD]Basic Fire Awareness[/TD]
[TD]Fraud[/TD]
[TD]Business Continuity[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]AEA[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD] [/TD]
[TD]AEA[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]AEA[/TD]
[TD="align: right"]18/09/2017[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD] [/TD]
[TD]BSP[/TD]
[TD="align: right"]03/05/2019[/TD]
[TD="align: right"]03/05/2019[/TD]
[TD="align: right"]03/05/2019[/TD]
[TD="align: right"]03/05/2019[/TD]
[TD="align: right"]03/05/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]BSP[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]01/07/2014[/TD]
[TD="align: right"]16/08/2013[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]BSP[/TD]
[TD="align: right"]01/08/2018[/TD]
[TD="align: right"]01/01/2015[/TD]
[TD] [/TD]
[TD="align: right"]01/01/2015[/TD]
[TD="align: right"]01/01/2015[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]BSP[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]13/02/2014[/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]26/02/2019[/TD]
[TD="align: right"]01/02/2013[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]16/01/2018[/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]17/01/2018[/TD]
[TD="align: right"]16/01/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD="align: right"]28/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD="align: right"]19/02/2019[/TD]
[TD="align: right"]06/12/2017[/TD]
[TD="align: right"]19/02/2019[/TD]
[TD="align: right"]06/12/2017[/TD]
[TD="align: right"]19/02/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD="align: right"]21/09/2019[/TD]
[TD="align: right"]10/07/1905[/TD]
[TD="align: right"]21/09/2019[/TD]
[TD="align: right"]21/09/2019[/TD]
[TD="align: right"]21/09/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]VH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD] [/TD]
[TD]VH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]VH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]VH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD] [/TD]
[TD]VH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]VH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
Joe
If column B is Blank (active record) then how many records in Column E are more than 11 months old (ie ready for annual refresher) then group the answers by team. a sample of the info is below, I couldn't attach an excel sample. I am creating tables and charts on a second tab.
Hope someone can help
[TABLE="width: 1386"]
<colgroup><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Leaver (X)[/TD]
[TD]Name[/TD]
[TD]Team[/TD]
[TD]Info[/TD]
[TD]Bias[/TD]
[TD]H&S[/TD]
[TD]Basic Fire Awareness[/TD]
[TD]Fraud[/TD]
[TD]Business Continuity[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]AEA[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD] [/TD]
[TD]AEA[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]AEA[/TD]
[TD="align: right"]18/09/2017[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD] [/TD]
[TD]BSP[/TD]
[TD="align: right"]03/05/2019[/TD]
[TD="align: right"]03/05/2019[/TD]
[TD="align: right"]03/05/2019[/TD]
[TD="align: right"]03/05/2019[/TD]
[TD="align: right"]03/05/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]BSP[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]01/07/2014[/TD]
[TD="align: right"]16/08/2013[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]BSP[/TD]
[TD="align: right"]01/08/2018[/TD]
[TD="align: right"]01/01/2015[/TD]
[TD] [/TD]
[TD="align: right"]01/01/2015[/TD]
[TD="align: right"]01/01/2015[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]BSP[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]13/02/2014[/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]26/02/2019[/TD]
[TD="align: right"]01/02/2013[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]16/01/2018[/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]17/01/2018[/TD]
[TD="align: right"]16/01/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD="align: right"]28/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD="align: right"]08/03/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD="align: right"]19/02/2019[/TD]
[TD="align: right"]06/12/2017[/TD]
[TD="align: right"]19/02/2019[/TD]
[TD="align: right"]06/12/2017[/TD]
[TD="align: right"]19/02/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD="align: right"]21/09/2019[/TD]
[TD="align: right"]10/07/1905[/TD]
[TD="align: right"]21/09/2019[/TD]
[TD="align: right"]21/09/2019[/TD]
[TD="align: right"]21/09/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]PMO[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]VH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD] [/TD]
[TD]VH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]VH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]VH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD] [/TD]
[TD]VH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]VH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
Joe