Next person due ?

[fireslguk]

Hi I have 3 columns

A and B and C

I enter details sometimes weekly or monthly each row

For A the date B the person and C the shift start and finish time

I have accumulated a number of rows over time from 2015

I have about 250 rows of data


How can I have excel propose the next person due ?


B can contain the same person if they have done a number of shifts