Hi, Belinda!
Thank you for the response & interesting formula! However, it doesn't work past the 5th row of data when I tested it (I had same issue with another variation I'd tried), it returns a #VALUE!.