FIND THE INEFFICIECNT STAFF FOR LAST 6 MONTHS

[ajaymanshani]

I have the following dataset

It contains the hrs every staff has worked in each month.. Now my requirement is to segregate these people based on the hrs they worked over last 6 months.

I mean the people who worked for 00:00 to 10:00 hrs (low hrs) for the whole six months should be shown together, people who worked for 00:00 to 10:00 hrs for any 5 months should be shown together, people who worked for 00:00 to 10:00 hrs for any 4 months should be shown together and so on.

Attached the dataset for reference.

[Qiu]

@ajaymanshani 
By any 5 months, you mean adding up the 5 months with least working hours?

or we have calculate each combinations of months?

[ajaymanshani]

Hey, By any five months what I mean is the staff who have low working hrs in 5 months out of 6 present in the dataset.

For example

AJAY

NOV - 00:00 DEC - 05:00 JAN - 06:00 FEB - 11:00 MAR - 00:00 APR - 00:00

So above this staff has low working hrs (00:00 to 10:00) for 5 months (except FEB)

[Qiu]

@ajaymanshani 
Thank you for the informaion.
Maybe this one helps?