Help needed with excel formula

Hi

Requesting your help for the below in excel. I have attached the word file with example corresponding to the below to retain formatting and table.

If S.No is same (e.g. 123), Kick is present in G2, then C2 (e.g. ABC) should be present in Column C for the same S.NO.
Based on above, C2 is repeated in C5. Then date in D5 must be on or after D2 date and before F2 date (since D2 & F2 are corresponding dates of C2 where initial ABC is present. If F2 had been blank, then D5 must be within 10 days of D2).

The above mentioned is the complete logic and a single result is expected into a separate column.

If any further information is needed, please let me know.

Thank you very much for your help.

Regards
Krishna