Hi Alan Thanks very much for your support and I will check out the links you sent to me.
Hi Alan Thanks for your quick response. Would you be able to select the whole row for each of the latest dates? I will use some of the other inf...
Hi Riny Thanks I was not thinking I had not converted the dates from text to proper dates and I have grouped the dates. I was not thinking. Than...
Hi Mynda Please disregard my attachment as I forgot to add one report. What I have attached is what is reported on a daily and monthly basis. ...
Hi Mynda Thanks for your reply. I am trying to count the number of staff by department who are either late or absent in one report on a daily an...
Good Day Sorry for not getting back sooner. Attached is the sample data requested. Thanks again for all your help.
Hi Riny Thanks very much so simple I feel stupid. It work perfectly and thanks for the tip.
Hi Mynda Thanks for your help. Such a simple solution. Dave
Hi Phil Sorry attached is the Excel file. regards Dave