I have a list clock times from a bio metric clocking system. The list is sorted alphabetical. I run down the list to see who has not clocked and put down the person's name and surname. I however need to get the names below one another without having to sort.
Biometric.jpg
Employee Clocked (Y/N)
Anna Joubert Y
Anton Kruger Y
Avhashoni Tshifaro Y
Bongekile Mtyali Y
Brighton Chinhaba Y
Chand Kamya N
Charllene Tsamba Y
Conrad Bonorchis Y
Dalikhaya Ntloko Y
Duduzile Segooa Y
Dzulani Rampfumedzi N
Elizna Labuschagne Y
Irfan Syed Y
Isaac Muranganwa Y
Jan Labuschagne N
Result should be:
Chand Kamya
Dzulani Rampfumedzi
Jan Labuschagne
Bookmarks