Welcome to the Tableau Forums!
I'm not sure if it is something in my system, but I am unable to open your Excel file. It seems to be corrupted. Can you try a new upload?
I am refering your excel but not clear with requirement, can you elaborate more.
Explain the logic.