OK

So i have a huge dataset showing staff clocking in and out times.

Column A: Staff ID
Column B: IN Time
Column C: Out Time
Column D: Lateness Time


Ok so bearing in mind this data set has 1000's of staff ID's and only some of the rows contain a lateness time (which is shown as a negative number, -10 means they were 10 minutes late).

I need a way of generating a table/list that is going to automatically count/say that this staff ID from column A appears to have a negative number in Column D this many times.

Obviously not every staff member has had lateness, so it would not be feasable to have EVERY staff member listed, only those who have a negative number in a column D.





Hope this is clear - and that someone can help!