Try
=C2<=SMALL(IF($B$2:$B$6="x",$C$2:$C$6),$F$1)
EFthequebs.xlsx
Try
=C2<=SMALL(IF($B$2:$B$6="x",$C$2:$C$6),$F$1)
EFthequebs.xlsx
I guess I'm not explaining what I need very well. I want the 2 (from F1) people with the lowest hours (from column C) who signed up (from column B) for overtime to be highlighted. So.... They have to have an X next to their name in column B AND have the lowest hours in column C. In my original example sheet it is highlighted how it SHOULD look if it were working the way I need it to.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks