Converting Google Sheet formula into excel

Hi All! I have a unique google sheet formula that a very kind person created for me. My issue is I need to see if there is a way to get this formula to work in excel. Now the interesting thing is ...