Formula if exist same name in same range

Hi Experts,

I have file with Name, From Date, To Date, Status columns, I want formula in Status columns if same name again coming in same range it will show" already exist"

example: Farhan exist 2 time in same range 8/30/18

Thanks in advance.
Farhan

yes both dates range

if 8/30/18 coming in "from date" and also is come on "to date" so it will exist.

Step1: Sort Name -> A toZ

Step2: Sort From date -> Oldest to Newest

Try this in E2:

=IF(A3<>A2,"",IF(B3<=C2,"Already Exist","Not Exist"))

Try this in D2:

=IF(AND(COUNTIFS(A:A,A2,C:C,">="&B2,B:B,"<="&C2)>1,COUNTIF(A$2:A2,A2)>1),"Already Exist","Not Exist")

This assumes that you want to look at the whole date range, not just the start and end dates.

Hi Phucam,
there are huge data and continuously data type daily basis, I just want when I type name with range it will show it is already exist or not, it will some confusion first sort and then formula will work.